Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This forum is where any logged-in member can create a knowledge article.
Hi I would like to share with you something which I thing can be very useful.
Many times I was asked how can pivot table in QV can be sorted and why can't we do the same way as it is done in straight table (by double click on the label)?
I was searching for the solution and most of them are quite complex or required macro which frankly saying I do not like very much.
So when you open the app (attached) you will find my approach to this problem. I haven't used any macro codes.
I had to use variable and Trigger in document properties
Whats more the sorting list is dynamic so reflect actual view of the measures in the table.
Hello,
I am trying to use the new P&L Pivot table function in Qlik Sense.
It works great except that I would like to create a style format template and I can't manage to do what I want.
How am I suppose to create the subtotals?
For instance, I've got the following account in my data:
Sales A
Sales B
Sales C
I would like my table to look like this:
Sales (which is just a title)
Sales A
Sales B
Sales C
Total Sales
Thus, How is Qlik Going to understand that it must link my 3 sales accounts to the sales titles, the sales subtotals and also understand that total sales is the sum of sales A+B+C?
Thank you for your help.