topic Re: Display Pivot Table Totals in QlikView

Display Pivot Table Totals

Tue, 17 Jul 2012 18:27:23 GMT

Is there a way to lock the totals shown at the bottom of a pivot table, similar to the way they are locked and always displayed on a chart? I can get it to total and show as a row, but it is not locked and scrolls within the table.

Thanks-

Griff

Re: Display Pivot Table Totals

Miguel_Angel_Baeyens — Wed, 18 Jul 2012 07:15:29 GMT

Hi,

Do you mean moving totals on top of the chart?

Hope that helps.

Miguel

Re: Display Pivot Table Totals

Wed, 18 Jul 2012 14:28:10 GMT

I think he means more like the "freeze pane" or freeze top row from Excel funcationality. In pivot table, the total "row", placed at the top or the bottom, scrolls with the data.

Is there any way to make it stick to the top or the bottom regardless of the scrolling of the table?

Re: Display Pivot Table Totals

pennetzdorfer — Tue, 04 Sep 2012 08:15:24 GMT

Hi,

did you find a solution to this issue? I found an idea http://community.qlik.com/ideas/2397 - but for some reason it has been closed ...

Regards,

Florian

Re: Display Pivot Table Totals

Tue, 04 Sep 2012 13:57:57 GMT

Hi - thank you for the follow-up. We didn't find a solution. We found a work-around where we created a container and created multiple text objects in it, to display the totals. Totally inefficient, but was the best we could do. I'm not sure why it was closed. However, I do welcome any suggestions you may have.

Thank You-

Mike

Sent from my iPhone