DB records are there it will load the data other wise load the already loaded data

[Ramu_i]

Hi All,

I have a app, scheduling the data every day at 4:00 PM, In DB some times data is not loaded for scheduling time, that time dashboard shows 0 records, In this situation if data is not loaded (DB has '0 ' records, or DB data is processing(Loading)), it will display the previous loaded data, if data is there then reload the data.

Advance thanks.

Ram

[anat]

have u tried incremental load

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

[Ramu_i]

Hi Anat,

Is there other way,  using the if condition?

Thank You.

Ram

[Joseph_Musekura]

Hi @Ramu_i ,

You can for example store the loaded data in a file (qvd for example), check the size of the QVD file using  "FileSize()>0" and repeat the process if the size is null

IF (FileSize('test.qvd')>0) THEN

ENF IF;
 

[Ramu_i]

Hi Joseph,

I tried ,But it's not working.

Ram