Above - not working on pivot table

[CuriousGeorge]

Hi,

I will need to get the prior month calculation on a column field. It does not work for certain months, probably because it is filter/split by quarter. Can anyone advise how to fix this issue? 

 

[Or · Accepted solution]

Assuming you want to track Above() through all of the dimensions, use Above(total test) instead of Above(test).

If you only want to track across certain dimensions, you'd typically need to use AGGR. Have a look at e.g. https://community.qlik.com/t5/QlikView-App-Dev/Above-function-with-2-dimensions/td-p/1433309

https://community.qlik.com/t5/App-Development/Problem-facing-when-using-Above-Multi-Dimension/td-p/1...

For discussion of similar issues.

[CuriousGeorge]

Above total fix it, thanks!