QlikView App Dev

[priyarane]

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

[neelamsaroha157]

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]

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

I want every time to be there for all the users

[neelamsaroha157]

I guess yes, but you need to test.

[vishsaggi]

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

[priyarane]

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

[priyarane]

for ex below if user select b then data should come like below expand all

[neelamsaroha157]

Didn't my trick work for you??

[priyarane]

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

[neelamsaroha157 · Accepted solution]

Check this out. It works on my end.