Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
priyarane
Specialist
Specialist

expand pivot table

Hi Community,

For pivot table I need one option like

I have dim1, dim2, dim2, and expression

when I click on + symbol on dim1 then all the values should expand I should not expand each and every plus symbol on dim1, dim2 like that

-Priya

1 Solution

Accepted Solutions
neelamsaroha157
Specialist II
Specialist II

Check this out. It works on my end.

View solution in original post

14 Replies
neelamsaroha157
Specialist II
Specialist II

Expand All the the fields & then right click on column 1 and select collapse all. Now when you'll click on expand it will expand all the fields.

priyarane
Specialist
Specialist
Author

is it dynamic/permanent for all the users on accesspoint ?

I want every time to be there for all the users

neelamsaroha157
Specialist II
Specialist II

I guess yes, but you need to test.

vishsaggi
Champion III
Champion III

Why cant you use Always fully expand check in Pivot table Presentaion tab. Like below?

Capture.PNG

priyarane
Specialist
Specialist
Author

users are not looking for always expand, they want when they click on first dimension + then that particular data should be expand all

priyarane
Specialist
Specialist
Author

for ex below if user select b then data should come like below expand allscreen.jpg

neelamsaroha157
Specialist II
Specialist II

Didn't my trick work for you??

priyarane
Specialist
Specialist
Author

no, when we close document and if you open it is not working,

neelamsaroha157
Specialist II
Specialist II

Check this out. It works on my end.