Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rnepla83
Partner - Creator
Partner - Creator

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

 

Labels (3)
9 Replies
thi_pham
Creator III
Creator III

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 

Vegar
MVP
MVP

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.

Ksrinivasan
Specialist
Specialist

Hi,

 

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

then DATA not upload automatically,

 

K. Srinivasan.

Ksrinivasan
Specialist
Specialist

Hi,

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

then DATA not upload automatically,

K. Srinivasan.

thi_pham
Creator III
Creator III

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

rnepla83
Partner - Creator
Partner - Creator
Author

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

rnepla83
Partner - Creator
Partner - Creator
Author

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.

rnepla83
Partner - Creator
Partner - Creator
Author

Hi!

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

 

Thanks

Ksrinivasan
Specialist
Specialist

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