Discussion Board for collaboration related to QlikView App Development.
Can somebody help me on this pls.
I have few order ID's where they keep changing their status on daily basis. Want to capture the last time updated record.
Suppose Order ID 14 in Day2 sheet of attached file updated 3 times on same day, my qlikview app refresh is also 3 times per day..so
I should capture only the last time it got updated for that day and should erase the other 2 records which updated that day.
Go to Solution.
Something like this should do the trick:
Date(Floor(Track_UpdatedDate)) as Track_UpdatedDay
SCD.xlsx (ooxml, embedded labels, table is Day2)
RIGHT JOIN (Data)
Max(Track_UpdatedDate) as Track_UpdatedDate
View solution in original post
FOR Each d in 'Day1', 'Day2'
rowno() as ID,
'$(d)' as Day,
(ooxml, embedded labels, table is $(d));
Where Order_ID <> Peek('Order_ID')
Order By Order_ID, Track_UpdatedDate desc, ID desc;
STORE T into T_$(d).qvd (qvd);
DROP Table T;
DROP Table tmp;
LOAD * from T_Day?.qvd (qvd);
Thanks Massimo and Gysbert for your prompt response...