value in one column equals to value 1 row after in another column

[#1]

Hi, how can I have column B take the value of the day after?:

Date	A	B
1-Jun	14	10
2-Jun	10	7
3-Jun	7	35
4-Jun	35	24
5-Jun	24	32
6-Jun	32

Thanks.

[nagaiank]

Use the following script to get the data in the table box shown below:

Table1:

LOAD RowNo() as ID, * Inline [

A

14

10

7

35

24

32

];

Table2:

LOAD ID, A, Peek(A) as B

Resident Table1 Order By ID desc;

[anbu1984]

Table1:

LOAD * Inline [

A

14

10

7

35

24

32

];

Table2:

LOAD A,Peek(A,RecNo(),'Table1') as B

Resident Table1 ;

[#4]

Hi,

Check the attached app if you want to handle it from the expression level.

Regrads,

Ravikumar

[senpradip007]

Use Below() function. Hope you will get your desire result.

[#6]

Hi, so sorry can you screenshot? I can only open files that I create myself. Thanks.

[maxgro]

source:

LOAD Date, A, B

FROM [http://community.qlik.com/thread/134649] (html, codepage is 1252, embedded labels, table is @1);

final:

noconcatenate

load   Date, A,

  peek(A) as B

Resident

  source

order by Date desc;

drop table source;

[#8]

Hi,

Create the chart like this

Straight Table:

Dim : Date

Exp1: Sum(A)   (Column Label A)

Exp2: Below(A) (Column Label B)

Here is the screen shot of the chart in the attached SampleApp of my earlier post.

Regards,

Ravikumar

[MarcoWedel]

tabInput:

LOAD Date, A

FROM [http://community.qlik.com/thread/134649] (html, codepage is 1252, embedded labels, table is @1);

Left Join

LOAD Date,

            Previous(A) as B

Resident tabInput

Order By Date desc;