topic Re: Pivot table expand in QlikView

Pivot table expand

Mon, 08 Feb 2016 20:06:30 GMT

Hi All,

I have multi dimension in qlikview pivot table. Lets say I have 4 dimension. I want to keep 1st 2 always open and rest two collapsed. What I have seen is you can have them all expanded all the time or it shows 1st dimension and then you keep hitting + icon to expand them one by one.

Now the question is " is there a way to get 2 dimension expanded all the time and next two in collapsed form? if users want, they can expand them.

Thanks in advance.

Max

Re: Pivot table expand

settu_periasamy — Tue, 09 Feb 2016 01:50:06 GMT

Hi,

check this link..

Pivot Table One Dimension Fully Expanded

Re: Pivot table expand

marcus_sommer — Tue, 09 Feb 2016 06:46:48 GMT

Instead of clicking on the + / - icons you (and your users) could use a right-click within these dimension and choose expand or collapse them all - it's very easy.

- Marcus

Re: Pivot table expand

amit_saini — Tue, 09 Feb 2016 06:54:06 GMT

Hi,

You can use this:

Thanks,

Re: Pivot table expand

avinashelite — Tue, 09 Feb 2016 09:21:00 GMT

As per my knowledge we don't have way in Qlikview to achieve the selective collapse ...please try to follow the suggestion from Marcus_Sommer‌ or you can select always expand option in the presentation tab