Discussion Board for collaboration on QlikView Scripting.
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.
Go to Solution.
Does this make sense?
(ooxml, embedded labels, table is Sheet1);
LOAD id, Sales1, Sales2,MonthEnd(Date) as Date Resident Main;