topic Re: expand pivot table in QlikView

expand pivot table

priyarane — Wed, 12 Apr 2017 15:32:17 GMT

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

Re: expand pivot table

neelamsaroha157 — Wed, 12 Apr 2017 15:34:45 GMT

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.

Re: expand pivot table

priyarane — Wed, 12 Apr 2017 15:54:45 GMT

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

I want every time to be there for all the users

Re: expand pivot table

neelamsaroha157 — Wed, 12 Apr 2017 17:02:28 GMT

I guess yes, but you need to test.

Re: expand pivot table

vishsaggi — Wed, 12 Apr 2017 17:27:57 GMT

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

Re: expand pivot table

priyarane — Wed, 12 Apr 2017 17:59:28 GMT

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

Re: expand pivot table

priyarane — Wed, 12 Apr 2017 18:08:53 GMT

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

Re: expand pivot table

neelamsaroha157 — Wed, 12 Apr 2017 18:12:03 GMT

Didn't my trick work for you??

Re: expand pivot table

priyarane — Wed, 12 Apr 2017 18:19:13 GMT

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

Re: expand pivot table

neelamsaroha157 — Wed, 12 Apr 2017 18:23:45 GMT

Check this out. It works on my end.

Re: expand pivot table

priyarane — Wed, 12 Apr 2017 18:28:54 GMT

what changes you have done, pls tell me

Re: expand pivot table

vishsaggi — Wed, 12 Apr 2017 18:29:40 GMT

I believe it is because you use access point to view your dashboard. I am not sure if that holds the expansion.

Re: expand pivot table

neelamsaroha157 — Wed, 12 Apr 2017 18:34:37 GMT

I am not sure why it is not working for you. It works on mine (desktop version as well as Access point).

Sorry, can't figure out what is the issue, may be someone else will .

Re: expand pivot table

priyarane — Wed, 12 Apr 2017 18:38:57 GMT

let me check on access point tomorrow till it is working on desktop, thanks for all your support

Re: expand pivot table

vishsaggi — Wed, 12 Apr 2017 18:46:18 GMT

It works for me too. Priya, can you try on your local desktop and in Access Point too and let us know.