Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Expand and Collapse in Straight table...

Expand and Collapse in Straight table...

2 Replies
MayilVahanan

HI

collapse and expand the dimensions are the features of pivot table. So use pivot table , instead of straight table..

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

The problem in Pivot table is it sums the values and shows it on collapse. But I want to show a total which will not be  a sum but some extra weightage added to it. The total for each dimension values would be provided in the data sheet. So by default I want to show the Total values there in the data sheet and on expand the other values for the dimension should be populated...