Hello,
In QlikSense, how can I add an additional row to my Pivot Table calculating the difference between the rows above it? I've searched all around and can't find how to do it as a row below my other rows.
I'm not looking to add the difference as a column to the right.
I want it to look just like the red text in this image:
Thanks!
Accepted Solutions
I got close to the desired result by using the method described here: Calculate Difference in Rows in Pivot
Unfortunately, it requires the user click a "disclosure" widget to open the upper level before the lower level can display. That makes it likely my customer will not see the detail I want them to see, since they are unlikely to interact with the worksheet.
It also places the total above the rows, which is counter-intuitive, but functional.
the sheet opens looking like this:
and expands to this:
I accept that Qlik Sense is not Excel, but its inflexible reporting and limited data graphics capabilities make it difficult. But since my company has decided it will be our one and only reporting platform, it is what I must work with.
I recommend you read the post I linked to. Basically, I used the DIMENSIONALITY() function, which lets you calculate differently based on whether the pivot table row is a header row or a dimension detail row.
Basically, it's this:
IF(Dimensionality()=1, **SUM GOES HERE**)
,
DIMENSION MEASURE GOES HERE)
)Then I used the Styling options for the Pivot Table to make it expanded at all times.
