Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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;
Table1:
LOAD * Inline [
A
14
10
7
35
24
32
];
Table2:
LOAD A,Peek(A,RecNo(),'Table1') as B
Resident Table1 ;
Hi,
Check the attached app if you want to handle it from the expression level.
Regrads,
Ravikumar
Use Below() function. Hope you will get your desire result.
Hi, so sorry can you screenshot? I can only open files that I create myself. Thanks.
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;
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
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;