"Above" function - not working - Qlik Community

jdgraham

I'm trying to do what should be a very simple task for the "Above" function. I have a table with very few columns. It would look something like:

DATE NBR

xx 5

xx1 4

I want to use the Above function to put in a new column with the difference and then calculate the percent of change.

It would be from above 5 minus the current row which is 4 - 5-4=1

Above formula should be something like

Above(NBR)-NBR (this would be taking the 5 to minus the 4)

If it is

NBR-Above(NBR) (this would be taking the 4 and minus the 5)

It will not work either way. Produces a column with nothing but " - " in it.

What is the correct process for this?

rubenmarin

Hi, I did a test and it returns the 1:

The row returning "-" could be the first, as it doesn't have any more "Above" records.

Maybe your tabel has more dimensions, in that case you can use: Above(TOTAL NBR)-NBR.

Can you post an example that shows the issue?

"Above" function - not working