Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
lourdesfmt
Contributor II
Contributor II

always with all the collapsed dimensions

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.

12 Replies
vishsaggi
Champion III
Champion III

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

Capture.PNG

neelamsaroha157
Specialist II
Specialist II

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

lourdesfmt
Contributor II
Contributor II
Author

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.

vishsaggi
Champion III
Champion III

Did you try checking that option in presentation tab?

lourdesfmt
Contributor II
Contributor II
Author

Yes

vishsaggi
Champion III
Champion III

So is it not working?

lourdesfmt
Contributor II
Contributor II
Author

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.

vishsaggi
Champion III
Champion III

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?

balabhaskarqlik

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