topic Re: Preserve the Reload time in QlikView

Preserve the Reload time

ferha_jafri — Fri, 25 May 2018 14:49:46 GMT

Hello All,

I have a condition in which I want to preserve the reload time , so that when the application runs again it show the last reload time.

I am attaching the sample application in which the reload time should preserve on the basis of the variable value.

Thanks in advance

Ferha Sharma

Re: Preserve the Reload time

ferha_jafri — Fri, 25 May 2018 14:57:56 GMT

Or I would say that I want to preserve the reload time even after the next reload.

Re: Preserve the Reload time

olivierrobin — Fri, 25 May 2018 15:38:26 GMT

hello

why don't you store it in a csv file ? (use STORE after you LOAD)

Re: Preserve the Reload time

rwunderlich — Fri, 25 May 2018 17:15:39 GMT

What is not working in the sample you posted?

-Rob

Re: Preserve the Reload time

ferha_jafri — Sat, 26 May 2018 02:16:06 GMT

Rob in the sample the condition is working but my issue is I have to store reload time for 2 tasks of the same application so for the 2nd time when application runs again it refresh the reload time for 1st task also and I want to preserve it to use it in front end of the application .

Re: Preserve the Reload time

ferha_jafri — Sat, 26 May 2018 02:17:56 GMT

Oliver yes I could do it but I have 2 tasks for the same application and they run one after the other so when application reload 2nd time first reload time also refresh.

Re: Preserve the Reload time

rwunderlich — Sat, 26 May 2018 18:05:56 GMT

The ReloadTime() function returns the time of the last completed reload. So if you want to display in the UI the last two reloads you can do so like this:

1. In your script. set a variable or load a field to ReloadTime().

2. In the UI display both this variable and ReloadTime() -- which gets reset when the load finishes.

In the script:

LET vLastReload = ReloadTime();

In the UI:

='Last Reload: ' & ReloadTime() & ", Previous Reload: " &vLastReload

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: Preserve the Reload time

ferha_jafri — Sun, 27 May 2018 06:30:56 GMT

Thanks for your reply Rob , I understood your point but the variable vLastreload also get refresh when we reload the application again so how should I stop vLastreload to refresh in the second reload.

Re: Preserve the Reload time

Gysbert_Wassenaar — Sun, 27 May 2018 09:35:08 GMT

Can you explain under which conditions the reloadtime should be refreshed and when it shouldn't be, but keep the value of the previous reload?

Re: Preserve the Reload time

ferha_jafri — Sun, 27 May 2018 10:06:56 GMT

Hi Gysbert,

I have to develop an application which shows applications and there corresponding reload times but the issue in this is one application gets reloaded twice or thrice through qmc and I have to show both reload times for both the tasks for same application so now the problem is when the same application gets reloaded 2nd time the last reload time also gets refreshed so I want to stop 1st reload time to refresh when 2nd reload happen.

Re: Preserve the Reload time

Gysbert_Wassenaar — Sun, 27 May 2018 10:37:05 GMT

Perhaps you should have a look at the Governance Monitor: https://help.qlik.com/en-US/governance-dashboard/2.0/Content/Publisher-sheet.htm

Re: Preserve the Reload time

tamilarasu — Mon, 28 May 2018 03:47:08 GMT

Hi Ferha,

Have a look at the attached file.

Re: Preserve the Reload time

ferha_jafri — Mon, 28 May 2018 07:46:48 GMT

Sorry but I did not understand your coding ,as what exactly is happening in your sample app.

Re: Preserve the Reload time

tamilarasu — Mon, 28 May 2018 07:56:43 GMT

Hi,

Before answering to your last question, can you confirm your requirement. I believe that you need to display last reload time and previously reload time in your application. Is that correct?

Re: Preserve the Reload time

ferha_jafri — Mon, 28 May 2018 08:40:51 GMT

Yes, I have 2 tasks for similar application and I want to show tasks reload time for the same application corresponding to tasks.

Re: Preserve the Reload time

tamilarasu — Mon, 28 May 2018 09:32:28 GMT

The red color highlighted text in below expression is a variable which was created by me i.e Last reload date and time will perform as an ARRAY function.

Let vReloadTime = Left(Date(Now(1),'MM/DD/YYYY hh:mm:ss TT') & '|' & vReloadTime,45);

The below part is to capture the application reload time. You may ask why I am using 1 in the now function. You should check the help file for the reason.

Date(Now(1),'MM/DD/YYYY hh:mm:ss TT') - Latest reload time

In the below step, I am concatenating the latest reload time with previously stored variable values (Date & Time).

Date(Now(1),'MM/DD/YYYY hh:mm:ss TT') & '|' & vReloadTime

You can test the expression like below.

As you can see, whenever you run the application the reload time will be concatenated and stored in a variable. In your case, you need to display last two reload times. So we can exclude rest of the reload times and keep only last two reload times.

For that I have manually hard coded second pipe symbol position which is 45. Hope you aware about left function.

So whenever you reload only the last two reload times will be stored and old ones will be excluded.

To display the reload times seperately in front end, I have used subfield function.

Did you reload the application and check the "Last Refresh" and "Previous Refresh" time? This is working fine as per your question.

Re: Preserve the Reload time

rwunderlich — Tue, 29 May 2018 16:59:09 GMT

vlastReload gets refreshed with the reload time of the next to last load. ReloadTime(), in the UI, is the last reload.