Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

priyarane
Contributor III

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
Valued Contributor II

Re: expand pivot table

Check this out. It works on my end.

14 Replies
neelamsaroha157
Valued Contributor II

Re: expand pivot table

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
Contributor III

Re: expand pivot table

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

I want every time to be there for all the users

neelamsaroha157
Valued Contributor II

Re: expand pivot table

I guess yes, but you need to test.

vishsaggi
Esteemed Contributor III

Re: expand pivot table

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

Capture.PNG

priyarane
Contributor III

Re: expand pivot table

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

priyarane
Contributor III

Re: expand pivot table

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

neelamsaroha157
Valued Contributor II

Re: expand pivot table

Didn't my trick work for you??

priyarane
Contributor III

Re: expand pivot table

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

neelamsaroha157
Valued Contributor II

Re: expand pivot table

Check this out. It works on my end.

Community Browser