topic Monthly Trigger Qlik Sense in Management & Governance

Monthly Trigger Qlik Sense

amrinder — Sat, 16 Nov 2024 06:11:13 GMT

Hello,

I want to reload my Qlik Sense Dashboard on the last day of month if its April it should reload on 30th Apr if its May it should reload on 31st May. Please guide.

Thanks,

Amrinder

Re: Monthly Trigger Qlik Sense

avinashelite — Tue, 02 Apr 2019 08:58:19 GMT

you need to do it in the script level or at the server reload level

If its in the script then

LOAD ...,

Date,

FROM ...

Where Date = Floor(MonthEnd(Date));

2. In the hub you will get the option to set for the last day of the month