
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Above - not working on pivot table
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?
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
For discussion of similar issues.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
For discussion of similar issues.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Above total fix it, thanks!
