Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

andreyfcdk91
New Contributor III

Insert peek values

Colleagues, good day!
Would be glad to get some advise to solve this task:

I have simple table with following structure:

1.jpg

i need to insert to this table several records (per each month) with this condition:
id - get previous id value

date - get monthend value

sales1 - get previous value

Sales2 - get previous value

so the result should be the following:

2.jpg

There's sample in the attachment.

Thanks.

1 Solution

Accepted Solutions

Re: Insert peek values

Does this make sense?

Capture.PNG

//Script:

Main:

LOAD id,

     Date,

     Sales1,

     Sales2

FROM

Test1.xlsx

(ooxml, embedded labels, table is Sheet1);

Join

LOAD id, Sales1, Sales2,MonthEnd(Date) as Date Resident Main;

2 Replies

Re: Insert peek values

Does this make sense?

Capture.PNG

//Script:

Main:

LOAD id,

     Date,

     Sales1,

     Sales2

FROM

Test1.xlsx

(ooxml, embedded labels, table is Sheet1);

Join

LOAD id, Sales1, Sales2,MonthEnd(Date) as Date Resident Main;

andreyfcdk91
New Contributor III

Re: Insert peek values

Thanks!)