database in-memory historical qlik sense

[#1]

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 ??

[Anonymous]

Not sure I fully understand your question. 

Could you clarify ?

[gsbeaton]

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.

[#4]

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

[gsbeaton · Accepted solution]

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.

[simondachstr]

You will need to model an incremental loading process if you wish to keep and maintain multiple snapshots of yourQlik Sense in-memory data.