Pivot Table UI - Representation Query - Qlik Community

VSuisse · ‎2019-08-20

Hi Folks,

I have a query about representation of data in a QlikSense Pivot table. I am trying to find easy way to display data in below format using QlikSense inbuilt pivot table and Vizlib extension but cant able to show it exactly same.

Expected result:

Problem with Sense pivot / Vizib pivot is

1. Total labels will always be static. i.e. Same label for all dimension values. (below screenshot)

2. Total labels are displayed beneath to next dimension rather than same dimension. (below screenshot)

Is there any other extension available to achieve this? Kindly share your inputs

Thank so much,

VS

Anonymous · ‎2019-08-20

Hi VS,

This should be possible with the Vizlib Pivot Table. There is documentation and screenshots showing various customizable options, including sub-headers, here: https://community.vizlib.com/support/solutions/articles/35000127357-vizlib-pivot-table-overview

What you're looking for is options around Dynamic Styling - which allows you to customize row by row. https://community.vizlib.com/support/solutions/articles/35000128880-vizlib-pivot-table-dimensions

It's how we made this custom P&L table:

Vizlib Pivot Table

VSuisse · ‎2019-08-20

Hi Jo,

Thank you my friend.

Vizlib has very cool features but I still cant get the below using Vizlib pivot table. I cannot make total / sub-total label names dynamic and they are still appearing beneath to the right column instead of same column like below (highlighted in yellow)

looking forward to hear from you soon.

Thanks much,

VS

Anonymous · ‎2019-08-21

Could you start a new topic in the Vizlib forums? It'll alert our support team and give you the best options: https://community.vizlib.com/support/discussions/forums/35000252046