topic Re: Insert peek values in QlikView

Insert peek values

Anonymous — Thu, 19 Oct 2017 17:45:30 GMT

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

I have simple table with following structure:

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:

There's sample in the attachment.

Thanks.

Anil_Babu_Samineni — Fri, 20 Oct 2017 01:59:45 GMT

Does this make sense?

//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;

Anonymous — Fri, 20 Oct 2017 12:06:33 GMT

Thanks!)