topic Re: always with all the collapsed dimensions in QlikView

always with all the collapsed dimensions

lourdesfmt — Mon, 26 Jan 2026 18:19:17 GMT

Hi,

Someone knows if there is an option to be able to configure that when opening a pivot table from the access point, this table is always with all the collapsed dimensions.

Some trigger, in the properties of the object or properties of the document.

I have read the properties of the pivot table in the reference manual but that option is not there.

Re: always with all the collapsed dimensions

vishsaggi — Wed, 12 Sep 2018 19:18:03 GMT

Check this box in presentation tab of your pivot table properties.

Re: always with all the collapsed dimensions

neelamsaroha157 — Wed, 12 Sep 2018 19:30:44 GMT

As vishsaggi‌ said, uncheck the 'fully expanded' option and collapse all dimension one by one until first one and save it.

Re: always with all the collapsed dimensions

lourdesfmt — Wed, 12 Sep 2018 19:38:58 GMT

Hi Neelam,

I already have the option unchecked and if I collapsed each dimension and saved.

but at the moment the user navigates and expands the dimensions.

wants to re-enter the application are all collapsed in automatic.

Re: always with all the collapsed dimensions

vishsaggi — Wed, 12 Sep 2018 19:49:05 GMT

Did you try checking that option in presentation tab?

Re: always with all the collapsed dimensions

lourdesfmt — Wed, 12 Sep 2018 19:55:33 GMT

Yes

Re: always with all the collapsed dimensions

vishsaggi — Wed, 12 Sep 2018 20:01:04 GMT

So is it not working?

Re: always with all the collapsed dimensions

lourdesfmt — Wed, 12 Sep 2018 20:10:12 GMT

No, because I would like an option where I say that I always collapsed when I entered.

If I deactivate that option what it does is expand everything and that is not what I need.

Re: always with all the collapsed dimensions

vishsaggi — Wed, 12 Sep 2018 20:14:41 GMT

Not sure i understood your requirement. So when you get to that sheet where your pivot is available it should fully expand? Right ? Did not get you what you mean deactivate option it does expand everything and this not what i want?

Re: always with all the collapsed dimensions

BalaBhaskar_Qlik — Thu, 13 Sep 2018 12:05:59 GMT

May be add a macro, to make all dimensions expanded...

sub ExpandCollapseDimensions

set chart = ActiveDocument.GetSheetObject("CH21")

set gp = chart.GetProperties

gp.TableProperties.PivotAlwaysFullyExpanded = 'true'

chart.SetProperties gp

end sub

Re: always with all the collapsed dimensions

thakkarrahul01 — Sat, 15 Sep 2018 03:06:47 GMT

Hi,

Qlikview tracks session for each user and if I understand correctly users are seeing pivot tables expanded when they enter through access point from second time (if they have expanded the pivot first time).

There is an option in QMC to stop this behaviour although this change in property applies across platform in my knowledge.

You can try changing it and test. You will require to go to QMC — System — Setup — Qlikview Server — Document — Uncheck Allow Session Recovery.

Hope this helps.

Regards,

Rahul

Re: always with all the collapsed dimensions

lourdesfmt — Tue, 18 Sep 2018 19:58:38 GMT

Hi Rahul,

if I worked by deactivating the box Allow Session Recovery

Thank you!!

Re: always with all the collapsed dimensions

thakkarrahul01 — Wed, 19 Sep 2018 19:49:39 GMT

That's Great