Save immutable values in a table and add new values continuously

[Malte]

Hi there,

i have the following task:

For an analysis, I need the values that have a date smaller than today's date. The problem is that today's date is changed with every new load, so the values from the past may have been changed in the meantime and are no longer taken into consideration in this logic.

So my question at this point is this:

Is there a possibility (as soon as the date is smaller than today) to store the values as a fixed value in a table and only add new values with each new load?

Thank you 

Cheers 

Malte

[Or]

Sounds like you're looking for an incremental load:

https://help.qlik.com/en-US/qlikview/May2022/Subsystems/Client/Content/QV_QlikView/QVD_Incremental.h...

[Malte]

Hi, 

thank you for the quick reply.

I have already thought about that, but I have no possibility to create new QVDs on the server (as far as i know). Are there any other possibilities?

[Or]

Perhaps you could try and achieve this using Partial Reload:

https://help.qlik.com/en-US/sense/May2022/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPrefixes/...

But I would strongly advise against trying, since this will "break" the first time you need to full-reload the app for any reason.

I suppose you could also try and achieve the same thing by keeping the old data in a separate Qlik Sense app and reference that app using Binary, but if you can't write a QVD file to this server, you probably can't reference a QVF on it either...