Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
Hi,
Just you stop the task schedule with respect to the APP in QMC,
then DATA not upload automatically,
K. Srinivasan.
Hi,
Just you stop the task schedule with respect to the APP in QMC,
then DATA not upload automatically,
K. Srinivasan.
@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.
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
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.
Hi!
Thanks, is the last alternative way, i would like to avoide this approach.
Thanks
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 |