I have a requirement for extracting data in Qlik Sense.
My data file Contains as below
The data gets added to data file month on Month, So My requirement is to extract Only the Latest Month Instead of Extracting all the months data.
My Output Should look like as below
I Cannot use Addmonths function because I am not sure when the Data gets updated in the data file, So the data extraction should be dynamic.
If you can share your thoughts it would be very helpful.
One way to do this
CrossTable (MonthYear, Data, 6)
[Need Help in data Extract.xlsx]
(ooxml, embedded labels, table is Sheet1);
Date(Num#(MonthYear), 'MMM-YY') as MonthYear,
DROP Table Table;
Right Join (FinalTable)
LOAD Max(MonthYear) as MonthYear
Wrote the script in QlikView, but should work the same way in Sense
Thanks very muvh sunny for quick reply.
I am trying to do incremental Load here.
In the first run the app should load all months data and from the next run it should pick only the latest month instead of reading all the months and concatenate with existing qvd.
I tried doing preceding but cant get the logic right.
Perhaps like this:
Month as Loaded,
CrossTable(Month, Value, 6)
Where Not(Exists(Loaded, Month));
DROP Table T_Fields;
You can't do a preceding load on top of a cross table load, so you have to do a load resident instead.