Discussion Board for collaboration on QlikView Scripting.
Hi, how can I have column B take the value of the day after?:
Use the following script to get the data in the table box shown below:
LOAD RowNo() as ID, * Inline [
LOAD ID, A, Peek(A) as B
Resident Table1 Order By ID desc;
LOAD * Inline [
LOAD A,Peek(A,RecNo(),'Table1') as B
Resident Table1 ;
Check the attached app if you want to handle it from the expression level.
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.
LOAD Date, A, B
FROM [http://community.qlik.com/thread/134649] (html, codepage is 1252, embedded labels, table is @1);
load Date, A,
peek(A) as B
order by Date desc;
drop table source;
Create the chart like this
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.
LOAD Date, A
Previous(A) as B
Order By Date desc;