topic Re: Pivot Table Expand / Collapse All in QlikView

Pivot Table Expand / Collapse All

Anonymous — Mon, 27 Jan 2014 15:29:35 GMT

Is there any way for collapsing and expanding the levels in a pivot table in their entirity without having to right click and then expand/collapse all?

Thanks

Re: Pivot Table Expand / Collapse All

Anonymous — Mon, 27 Jan 2014 15:33:46 GMT

Adrian

Why do you find the right click and then expand/collapse all unsatisfactory ?

Best Regards, Bill

Re: Pivot Table Expand / Collapse All

Anonymous — Mon, 27 Jan 2014 15:35:19 GMT

I want to make it easier for the user

Re: Pivot Table Expand / Collapse All

jagan — Mon, 27 Jan 2014 15:35:19 GMT

Hi,

I think it is possible with macro and calling it when a button is clicked.

Regards,

Jagan.

Re: Pivot Table Expand / Collapse All

Thu, 06 Feb 2014 07:30:39 GMT

Hi Jagan,

Can you please provide me a sample macro to collapse all fields of a pivot table. I could not find it anywhere.

Re: Pivot Table Expand / Collapse All

petra_ds — Mon, 13 Mar 2017 09:49:31 GMT

Hi, please me too. I dont find any macro. Is there also some functionality, not only collaps / expanse all fields, but only some fileds starting on the column, I actually use? Something similar as it was possible in qlik view???

Re: Pivot Table Expand / Collapse All

sangland2 — Thu, 20 Apr 2017 05:20:34 GMT

Hi Bill, I have many sheets with many pivot tables. I want to be sure that when I save the qvw that all are fully collapsed and ready for users. Found the macro below in another post. This works to change the AlwaysFullyExpanded option to false but does not actually Collapse All. The saved qvw retains expanded columns and they appear like this when users open the model from the access point. Is there a solution for this ?

Sub collapsePivotTable

CollapsePivot("CH50")

End Sub

Function CollapsePivot (objectID)

Set chart = ActiveDocument.GetSheetObject(objectID)

set ch=chart.GetProperties

ch.TableProperties.PivotAlwaysFullyExpanded=false

chart.SetProperties ch

End Function

Re: Pivot Table Expand / Collapse All

maxime66 — Thu, 31 Aug 2017 09:44:01 GMT

Hi,

Another way consists to Hide/Unhide dimensions according to a variable...

Re: Pivot Table Expand / Collapse All

thomaslg_wq — Thu, 14 Sep 2017 06:38:52 GMT

Hi,

For those who are still looking for it : How to Get QlikView Pivot Charts to Behave – Everything in its Place

Re: Pivot Table Expand / Collapse All

Anonymous — Wed, 11 Jul 2018 12:25:20 GMT

Unfortunately the print screens aren't available anymore. Im still looking for solution to expanding/collapsing all. Any help?

Re: Pivot Table Expand / Collapse All

thomaslg_wq — Wed, 11 Jul 2018 17:29:08 GMT

You do not need the print screens as it is explained : in a few words ==> deal with bookmarks

Re: Pivot Table Expand / Collapse All

ramasaisaksoft — Wed, 11 Jul 2018 17:57:07 GMT

If possible ,instead of Macros

simply put 2 charts in a Container

1 is Expanded manner

2nd is Collapsed manner

Re: Pivot Table Expand / Collapse All

maxime66 — Mon, 23 Jul 2018 08:42:17 GMT

Hi Kevin,

My Hide/Unhide solution below don't satisfy you neither ?