topic Re: Save immutable values in a table and add new values continuously in Reporting Service & Alerting

Save immutable values in a table and add new values continuously

Malte — Fri, 15 Nov 2024 22:06:11 GMT

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

Re: Save immutable values in a table and add new values continuously

Or — Wed, 27 Jul 2022 11:44:45 GMT

Sounds like you're looking for an incremental load:

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

Re: Save immutable values in a table and add new values continuously

Malte — Wed, 27 Jul 2022 11:48:10 GMT

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?

Re: Save immutable values in a table and add new values continuously

Or — Wed, 27 Jul 2022 11:54:58 GMT

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/PartialReload.htm

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