Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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.
Above total fix it, thanks!