Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
we have a database that refreshing his contains, therefore i need to store the last contains in-memory qliksense. For example if i want to do a dashbord with the dates i cant i have the last ones to make an evolution ??
Yes, you can do something like this:
TEMP:
Load
Max(Date) as MaxDate
Resident TableWithDate;
LET vMaxDate = peek('MaxDate');
Drop Table TEMP;
Then use your variable vMaxDate within your application for your expressions.
Not sure I fully understand your question.
Could you clarify ?
It sounds like you are trying to get the latest refresh date for a table of data in a database. You could try getting the data into a temporary table, sorting it by date then using the PEEK function to get the largest date into a variable. You can then use that variable within QlikSense for your chart logic.
Hi,
Thanks george im a beginner can you be more specific, Bill it's the logic of george that im searching can you help also with example
Yes, you can do something like this:
TEMP:
Load
Max(Date) as MaxDate
Resident TableWithDate;
LET vMaxDate = peek('MaxDate');
Drop Table TEMP;
Then use your variable vMaxDate within your application for your expressions.
You will need to model an incremental loading process if you wish to keep and maintain multiple snapshots of yourQlik Sense in-memory data.