Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Partner
Partner

How to avoid data load in qlik sense

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

 

9 Replies
Highlighted
Contributor II

Re: How to avoid data load in qlik sense

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 

Highlighted
Partner
Partner

Re: How to avoid data load in qlik sense

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.

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
Highlighted
New Contributor III

Re: How to avoid data load in qlik sense

Hi,

 

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

then DATA not upload automatically,

 

K. Srinivasan.

Highlighted
New Contributor III

Re: How to avoid data load in qlik sense

Hi,

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

then DATA not upload automatically,

K. Srinivasan.

Highlighted
Contributor II

Re: How to avoid data load in qlik sense

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

Highlighted
Partner
Partner

Re: How to avoid data load in qlik sense

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

Highlighted
Partner
Partner

Re: How to avoid data load in qlik sense

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.

Highlighted
Partner
Partner

Re: How to avoid data load in qlik sense

Hi!

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

 

Thanks

Highlighted
New Contributor III

Re: How to avoid data load in qlik sense

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