topic Re: How to avoid data load in qlik sense in App Development

How to avoid data load in qlik sense

rnepla83 — Sat, 16 Nov 2024 19:53:40 GMT

Hi community,

We need to avoid the pubblication phase in our QlikSense App, in some circustances (i.e. No Data Updated).

The app is been reloaded every 30 mins, the desired effect is to control the data reload and avoid RAM flush.

Is that Possible by the QMC or Scripting?

Thanks,

Paolo

Re: How to avoid data load in qlik sense

thi_pham — Wed, 16 Oct 2019 04:25:39 GMT

I think you can do a kind of checking in data load script:

Pseudo code:

if $(vDataChange) then

// Reload data

else

// Do nothing

end if

To define vDataChange, it will be defined up to your data, such as you you a datetime or sorted order field, then compare new data with max(field) -> you can track if data is updated. Otherwise, you can use checksum to check if there is any change in your data.

Hope it helps.

Calculate checksum of

Re: How to avoid data load in qlik sense

Vegar — Wed, 16 Oct 2019 04:56:28 GMT

If this is an app that is accessed through the hub then the pseudo code above will result in an empty app by not loading any data.

The quite ugly workaround to not load any new data and still keep the old data is to generate an error in the ELSE statement.

Pseudo code:

if $(vDataChange) then

// Reload data

else

Generating a forced error;

end if

The prettier solution is to use the open Qlik Sense APIs to trigger the application. Maybe let the source system that is generating the file trigger the task execution.

Re: How to avoid data load in qlik sense

Ksrinivasan — Wed, 16 Oct 2019 05:03:41 GMT

Hi,

Just you stop the task schedule with respect to the APP in QMC,

then DATA not upload automatically,

K. Srinivasan.

Re: How to avoid data load in qlik sense

Ksrinivasan — Wed, 16 Oct 2019 05:09:33 GMT

Hi,

Just you stop the task schedule with respect to the APP in QMC,

then DATA not upload automatically,

K. Srinivasan.

Re: How to avoid data load in qlik sense

thi_pham — Wed, 16 Oct 2019 06:19:51 GMT

@Vegar : you're right, I forgot that situation. Thanks for fixing me.

Then, why dont we load data and store to qvd file (which optimized for Qlik to read & write). Similarly to the way we do incremental load. It'll help to get a better performance and avoid impact to the data source if this is the case.

Otherwise, a small C# app which call Qlik Rest API can help.

Re: How to avoid data load in qlik sense

rnepla83 — Wed, 16 Oct 2019 10:14:51 GMT

hi Guys,

thanks for the replies.

Visisting some site on gg don't you think is a good approach to make API calls in QS Script, using REST Connector?

https://support.qlik.com/articles/000048617

Thanks

Re: How to avoid data load in qlik sense

rnepla83 — Wed, 16 Oct 2019 10:18:03 GMT

thanks a lot,

I don't think is the approach we need.

We need to stop the Task because is related to another task that run on it success.

So, if you use exit script, is like the task is done as well.

Paolo.

Re: How to avoid data load in qlik sense

rnepla83 — Wed, 16 Oct 2019 10:19:35 GMT

Hi!

Thanks, is the last alternative way, i would like to avoide this approach.

Thanks

Re: How to avoid data load in qlik sense

Ksrinivasan — Wed, 16 Oct 2019 11:13:21 GMT

Hi,

I have faced the same situation in my testing,

For that I have load the data and save it as Test.qvd and it schedule to run in the morning 8.00 am.

I have crated another APP to run with out DATA (which has having same header only as Test.qvd)

and overwrite in Test.qvd file by 9.00 schedule.

upto 8.59 actual data available in Test.qvd,

after overwrite app running at 9.00, No data in Test.qvd.

i hope you will like that,

K. Srinivasan