Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem with the above() function

Hi,

I am having a problem with the above function in a straight table. I would like to display the value of the previous row from column (EKPO_BEDAT) in the expression field. I thought this would be possible with the above function.

 

EKPO_MATNR_EMLIFEKPO_BEDATEKPO_MATNREKPO_EMLIFEKPO_row_counterEKPO_counterAbove(EKPO_BEDAT)
#-M500D00_29.07.2015#-M500D00 1354-
#-M500D00_29.07.2015#-M500D00 1364-
#-M500D00_29.07.2015#-M500D00 1374-
#-M500D00_29.07.2015#-M500D00 1544-
_21.06.1995 15812-
_21.06.1995 15912-
_06.02.2003 3712-
_04.12.2003 2212-
_30.12.2013 3112-
_02.01.2014 3212-
_28.01.2014 3512-
_04.03.2014 4012-
_11.05.2014 4812-
_20.08.2014 10112-
_11.09.2014 10212-
_10.04.2015 15312-
1SS01TE2713_29.06.20141SS01TE2713 553-
1SS01TE2713_30.06.20141SS01TE2713 543-

If I only have the EKPO_BEDAT column in the table, the expression is working:

 

EKPO_BEDATabove(EKPO_BEDAT)
21.06.199519.06.1995
26.06.199521.06.1995
27.06.199526.06.1995
28.06.199527.06.1995
11.07.199528.06.1995
29.01.199611.07.1995
30.01.199629.01.1996
19.02.199630.01.1996
05.03.199619.02.1996
13.03.199605.03.1996
28.03.199613.03.1996
24.04.199628.03.1996
26.05.199724.04.1996
27.05.199726.05.1997
20.07.199827.05.1997
28.03.200220.07.1998
15.01.200328.03.2002

Any help on how to solve this would be greatly appreciated!

3 Replies
sunny_talwar

May be try with TOTAL

Above(TOTAL EKPO_BEDATExpression)

Not applicable
Author

Great, thanks for the help, that worked!

Not applicable
Author

Good learning