Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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:
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
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