topic Re: pivot table is always with all the collapsed dimensions in App Development

pivot table is always with all the collapsed dimensions

lourdesfmt — Wed, 12 Sep 2018 19:19:46 GMT

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: pivot table is always with all the collapsed dimensions

giovanneb — Wed, 12 Sep 2018 20:40:37 GMT

Hi, Qlikview ou Qliksense?

Re: pivot table is always with all the collapsed dimensions

BalaBhaskar_Qlik — Thu, 13 Sep 2018 10:21:59 GMT

Try this:

Qlik Sense - Pivot Table Extension

Re: pivot table is always with all the collapsed dimensions

BalaBhaskar_Qlik — Thu, 13 Sep 2018 10:22:14 GMT

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

Re: pivot table is always with all the collapsed dimensions

lourdesfmt — Mon, 17 Sep 2018 13:19:29 GMT

Hi Giovanne, it is in QlikView

Re: pivot table is always with all the collapsed dimensions

BalaBhaskar_Qlik — Tue, 18 Sep 2018 11:28:55 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: pivot table is always with all the collapsed dimensions

lourdesfmt — Tue, 18 Sep 2018 19:56:16 GMT

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!!

Re: pivot table is always with all the collapsed dimensions

BalaBhaskar_Qlik — Sat, 22 Sep 2018 11:49:37 GMT

Ok, I'll too try for this.