Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
ShellyG
Creator
Creator

Pivot Table Expand Only Left Rows

Dear all,

I have a question regarding the pivot table.

I have a pivot table with expandable columns and rows and the table is using a calculation that is resulting in percentage. The issue is that when nothing is expanded, the table shows 100% everywhere (which is correct behavior considering that nothing is expanded). I found the option to expand all but it doesn't work for me, as I would prefer if not all are expanded. 

My question here is - is there a way to expand only the rows to the left, so that the pivot table is not summing up to 100%.

Thanks in advance!

Best Regards,

Shelly

Labels (1)
1 Reply
Wlad_Masi
Employee
Employee

Hello @ShellyG ,

 

Partial expansion is not something you can do today, but it could be a feature request on our  Qlik Ideas forum.

To help users find verified answers, please don't forget to mark a correct resolution or answer to your problem or question as correct.