Discussion Board for collaboration related to QlikView App Development.
Hi I have the following data and I want to extract for every month and item ONLY the last month day stock data in the loading script.
Many thank's guys
PS: In the excell attached there is only one item 😉
Go to Solution.
(biff, embedded labels, table is Sheet1$);
LOAD ItemId, Date(Max(DateStock)) as DateStock
GROUP BY ItemId, MonthName(DateStock);
You can create a flag that help you to know if the date is the last day of every month
you can use this in your script
if(CalendarDate=Date(Floor(MonthEnd(CalendarDate))),1,0) as end_Flag
Then you can do a resident load that only bring data if END_FLAG = 1
you will load only the last day of every month
Brilliant!! many thank's