pivot table is always with all the collapsed dimensions

[lourdesfmt]

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.

[giovanneb]

Hi, Qlikview ou Qliksense?

[BalaBhaskar_Qlik]

Try this:

Qlik Sense - Pivot Table Extension

[BalaBhaskar_Qlik]

https://github.com/jgerardoc/QlikSense-Ext-JSPivotTable

[lourdesfmt]

Hi Giovanne, it is in QlikView

[BalaBhaskar_Qlik]

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

[lourdesfmt]

Hi Bala,

Uncheck the box "Allow Session Recovery" en la QMC and it worked

QMC — System — Setup — Qlikview Server — Document — Uncheck Allow Session Recovery

thanks!!

[BalaBhaskar_Qlik]

Ok, I'll too try for this.