Save KPI values monthly

[laineee]

Hi,

I'm new user in this Qlik world. Though, I work with item data which is updated daily, so I have no solid dates and values to use, those are changing all the time.

I've created some KPIs, and as for an example: Count of items with empty cell in column "ASD" = 652000. So in the ERP will be done a data update that decreases the missing data cells to 542000. 

So how can I create a KPI that saves the filtered values e.g. monthly, with date stamp? That I can see the progress and create magnificent visualizations of it? 

Thank you and regards,

Eero

[Ralf_Heukäufer · Accepted solution]

Hello Eero,

if you want to save data you can calculate it in the loadscript and save it monthly as a qvd file.

https://help.qlik.com/en-US/sense/November2018/Subsystems/Hub/Content/Sense_Hub/Scripting/work-with-...

Every month you can concatenate the new data then.

https://help.qlik.com/en-US/sense/November2018/Subsystems/Hub/Content/Sense_Hub/LoadData/use-QVD-fil...