Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
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...