Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
We're new to Qlik as an organisation. We are running batch processes (SAS) to create files overnight (e.g. CSV) that the Qlik Sense (Feb18) apps can then upload.
Naturally some days there are overnight issues with the files created. What methods do you use to signal to your users that there has been an issue and the data within the app has not been refreshed?
I'd love to know how other organisation have approached this. We have a mixture of users some of whom will check reload dates, and some won't.
thanks
Ross
If you want something simple that can be displayed on a sheet in the application, you can place a text box or KPI object on your sheet and use the ReloadTime() function to display the last reload date/time. Combine that with a process that manages your downloaded files such as:
If you are currently looping through a folder full of SAS files, you might consider saving your data to a QVD file and do incremental loads to add each day's new SAS file to the QVD file, delete SAS file using Powershell, repeat.
Although I haven't tried it myself, I know there is a tool available from Qlik Branch
As administrators we have used nPrinting to notify us of failures on a timing schedule.
My question was more about signalling the reload status of an app to the end users.
If you want something simple that can be displayed on a sheet in the application, you can place a text box or KPI object on your sheet and use the ReloadTime() function to display the last reload date/time. Combine that with a process that manages your downloaded files such as:
If you are currently looping through a folder full of SAS files, you might consider saving your data to a QVD file and do incremental loads to add each day's new SAS file to the QVD file, delete SAS file using Powershell, repeat.