Any way a database model QTableView could have an extra "total" row?

JonB

@Christian-Ehrlicher
I did not say lots of things!

I have a well-established working set of tables/models/views. They do lots of things: sorting, filtering, editing, special display of values, .... Now I want an extra row at the bottom, sometimes, so I can display totals in certain numeric columns. Other columns in that row will be blank. The first column may well need to display a "Total" text, even if that column normally displays something else. I want everything to work just as it did, and then a total row as well.

Oh, and btw: if the code sorts now, I don't expect to have to "set the sort role to something else" to make something work. I expect the addition of the total row not to require much changes to existing code (other than my calculating it from the model, obviously).

:)

JonB

@Christian-Ehrlicher
The more I think about it, the more it seems to me what I really want is a "footer" like the header row, not as a row in the table, so I can put arbitrary text there like in the column headers. In my C# ASP.NET, tables had a (optional) footer as well as a header!

I looked into this, and it seems that QTableViews have no option for a footer. The only way is to write a lot of code yourself, including fiddling with the QTableView's area to accommodate the footer, which is well beyond the scope for me here.

JonB

Since it can't be done, I ended up making do, in my particular case, with an extra row in the model, using a QStandardItemModel.

Not happy, but needs-must! :)

SGaist

Hi,

Maybe the Frozen Column example might give you some ideas.

JonB

@SGaist
And so it might, for others who read this. For me, at least in this situation, anything more than about half a dozen lines is deemed "too complex/too much effort"! Multiple views, viewports, scrollers etc. is way too much for my situation.

Now, if Qt decides to add a (optional) footer to a QTableView in the way it has added a header, please let me know :)

StarterKit

Hi all,
Sorry for necro-posting but I don't think it deserves new separate topic.
Do I understand right that nothing have changed since 2019? I.e. we still have no good way to have a footer row in QTableView?

Basically a dozen code lines is what I was looking for... but I feel myself ready to make some extra class if required... but... I'm not sure that there is any good option to implement it rather than onces discussed above in this topic.

SGaist

@StarterKit hi,

It depends a bit on what you want to show and how.

A proxy model could also be used.

StarterKit

@SGaist I need exactly the same as @JonB described.
I use a working application with tables/models/views and I need to add a footer to a couple of QTableViews that would be able to show total sum of this column.

JonB

@StarterKit
I don't recall my exact situation or what I understood then, but knowing what I do now I only know there is just adding a (identity) proxy model appending one more row. It would have to come on top of any sort proxy. Certainly QTableView has not introduced a footer :)

StarterKit

@JonB ok, thank you for your comment, it is ok.
My idea might be a bit strange... but I managed to add one more QHeaderView below the table, it looks good.
So I subclassed it and created my own FooterView class to handle paintSection() event and provide data from the model with custom User-role.
I don't need fancy UI style and column movments so I think I'll survive with this solution :)

JonB

@StarterKit
Sounds good. I think mine was very specifically wanting an extra row at the bottom of the table rows, as an extra row.