Problem with the above() function

Wed, 19 Aug 2015 08:19:31 GMT

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_EMLIF	EKPO_BEDAT	EKPO_MATNR	EKPO_EMLIF	EKPO_row_counter	EKPO_counter	Above(EKPO_BEDAT)
#-M500D00_	29.07.2015	#-M500D00		135	4	-
#-M500D00_	29.07.2015	#-M500D00		136	4	-
#-M500D00_	29.07.2015	#-M500D00		137	4	-
#-M500D00_	29.07.2015	#-M500D00		154	4	-
_	21.06.1995			158	12	-
_	21.06.1995			159	12	-
_	06.02.2003			37	12	-
_	04.12.2003			22	12	-
_	30.12.2013			31	12	-
_	02.01.2014			32	12	-
_	28.01.2014			35	12	-
_	04.03.2014			40	12	-
_	11.05.2014			48	12	-
_	20.08.2014			101	12	-
_	11.09.2014			102	12	-
_	10.04.2015			153	12	-
1SS01TE2713_	29.06.2014	1SS01TE2713		55	3	-
1SS01TE2713_	30.06.2014	1SS01TE2713		54	3	-

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

EKPO_BEDAT	above(EKPO_BEDAT)
21.06.1995	19.06.1995
26.06.1995	21.06.1995
27.06.1995	26.06.1995
28.06.1995	27.06.1995
11.07.1995	28.06.1995
29.01.1996	11.07.1995
30.01.1996	29.01.1996
19.02.1996	30.01.1996
05.03.1996	19.02.1996
13.03.1996	05.03.1996
28.03.1996	13.03.1996
24.04.1996	28.03.1996
26.05.1997	24.04.1996
27.05.1997	26.05.1997
20.07.1998	27.05.1997
28.03.2002	20.07.1998
15.01.2003	28.03.2002

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

Re: Problem with the above() function

sunny_talwar — Wed, 19 Aug 2015 15:15:21 GMT

May be try with TOTAL

Above(TOTAL EKPO_BEDATExpression)

Re: Problem with the above() function

Thu, 20 Aug 2015 06:21:16 GMT

Great, thanks for the help, that worked!

Re: Problem with the above() function

Thu, 20 Aug 2015 10:41:19 GMT

Good learning

topic Re: Problem with the above() function in QlikView

Problem with the above() function

Re: Problem with the above() function

Re: Problem with the above() function

Re: Problem with the above() function