topic Re: Show/Hide based on last refreshed date in QlikView

Show/Hide based on last refreshed date

Thu, 20 Feb 2014 16:53:15 GMT

Hi, I am trying to find out how to do the following:

When a dashboard hasn't refreshed for >24hrs, I'd like a message to be displayed (automatically) on the opening tab of the dashboard, so when a user goes to the accesspoint, they will be able to see the message. Is there a way to set up the dashboard file that has been distributed to the documents folder (i.e. hidden script) to auto reload if it hasn't been refreshed in >24 hours?

Thanks!

Mike

Re: Show/Hide based on last refreshed date

quwok — Thu, 20 Feb 2014 17:23:48 GMT

Hi Mike,

you can derive it using the following logic:

= if(Now() < Timestamp(ReloadTime() + 1), 'Less than a day ago' , 'More than a day ago')

This translates to the following condition which you can paste into the show condition of your label

= not(Now() < Timestamp(ReloadTime() + 1))

(Note the above is more focus on readability than efficiency )

Re: Show/Hide based on last refreshed date

Thu, 20 Feb 2014 17:35:51 GMT

Thanks for the response. This part I can do, but it doesn't address the reload of the dashboard if the >24hrs condition is met.

Re: Show/Hide based on last refreshed date

Anonymous — Thu, 20 Feb 2014 17:41:30 GMT

Michael

Are your dashboard qvw's scheduled to be auto reloaded ? [I use Publisher to schedule auto reload tasks]

If so then how often ?

If you have scheduled reloads and they are failing then maybe it would be better to eliminate the root cause of the failures.

Best Regards, Bill

Re: Show/Hide based on last refreshed date

Thu, 20 Feb 2014 17:45:59 GMT

Hi Bill, thanks for the reply. The tasks themselves are not failing. I have everything set up on EDX triggers. So, if an ETL job is running behind for whatever reason, once it has been 24hrs since the last refresh, i want users to be notified.

Re: Show/Hide based on last refreshed date

Anonymous — Thu, 20 Feb 2014 17:56:46 GMT

Michael

Fair cop.

Quwok suggested earlier how the Users could be notified.

If an ETL job is running behind for whatever reason, then auto forcing a reload of the dashboard could well be unwise until the reason is identified & sorted,

Best Regards, Bill

Re: Show/Hide based on last refreshed date

Thu, 20 Feb 2014 18:00:09 GMT

Hi Michael,

Using QEM you can notify your users, just program an alert mail and add mail accounts that you want.

Best regards

Re: Show/Hide based on last refreshed date

Thu, 20 Feb 2014 19:00:33 GMT

I already have an alert set up if the job fails. This is for a job running longer than expected.