Qlik Sense Pivot vs QlikView Pivot

[Fabiano_Martino_Intelco]

Hi,

we are porting some QlikView apps to Qlik Sense and noticed some differences and limits between the QlikView pivot and the Qlik Sense Pivot.

In fact in Qlik Sense I found two pivot objects, the Charts pivot and the Visualization Bundle pivot.

Their behaviour is somewhat different.

Any suggestion regarding which one should be used (considering the posts in the ideation portal I would choose the Visualization one)?

Both charts have the option to expand/collapse all dimensions, while the QlikView pivot allows to collapse/expand individual dimensions.

Considering the level of analysis our users perform the lack of this feature is limiting.

Any suggestion or workaround about this missiong feature?

Regards

Fabiano

[SunilChauhan]

Better use Charts pivot  which is Original. use below link may help you
https://community.qlik.com/t5/Suggest-an-Idea/Qlik-Sense-Pivot-table-quot-Expand-collapse-ALL-quot-o...

[Or]

We ended up using a third-party extension (Vizlib Library) to work around at least some of the limitations in Qlik Sense's pivots, which sadly leave an awful lot to be desired compared to QlikView's (or Excel's) pivots.

The pivot in the bundle is meant to eventually replace the "regular" pivot. I would recommend using whichever one fits your needs at the moment, but keep in mind the one in the bundle is where new features are more likely to appear.

I think I have a list somewhere of the assorted options we found lacking in Sense vs. Qlik and what the options were. If you'd like, shoot me a direct message and I'll try fishing through my archives for it (or if you have any specific questions, you can send me those).

[joostvanegmond7]

In the new pivot table it is possible now to expand and collapse on a single level!