Discussion Board for collaboration on QlikView Layout & Visualizations.
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
Go to Solution.
Check this out. It works on my end.
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.
is it dynamic/permanent for all the users on accesspoint ?
I want every time to be there for all the users
I guess yes, but you need to test.
Why cant you use Always fully expand check in Pivot table Presentaion tab. Like below?
users are not looking for always expand, they want when they click on first dimension + then that particular data should be expand all
for ex below if user select b then data should come like below expand all
Didn't my trick work for you??
no, when we close document and if you open it is not working,