Qlik Community

Ask a Question

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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

DateAB
1-Jun1410
2-Jun107
3-Jun735
4-Jun3524
5-Jun2432
6-Jun32


Thanks.

8 Replies
Specialist III
Specialist III

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;

Capture.PNG.png

Master III
Master III

Table1:

LOAD * Inline [

A

14

10

7

35

24

32

];

Table2:

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

Resident Table1 ;

Not applicable

Hi,

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

Regrads,

Ravikumar

Specialist III
Specialist III

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

Not applicable

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

MVP
MVP

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;

Not applicable

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.

Chart.PNG.png

Regards,

Ravikumar

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;