topic specific date in App Development

specific date

Manni_SM — Thu, 28 Aug 2025 09:35:56 GMT

Hi All

i have qliksense application usally we are running manually evrymonth 10th .

now customer is asking to run it automatically every month 10

conditons: if 10th day is saturday or sunday (weekend) it should run on monday

and exclude all holidays also

this should be done in Qliksense script not from qmc.

any sample Qliksense app is there that will be helpful

how to do any ideas suggestions ? @Vegar @rubenmarin @QFabian

Re: specific date

rubenmarin — Thu, 28 Aug 2025 10:03:58 GMT

Hi, you can load the app every day, or from 10th to 13th, 14th, 15th, or wathever day that can avoid many consecutive holidays... it's not clear what it should do if 10 is saturday or sunday, and the next monday is holiday.

At the start of the script you can load a table with all holidays, the check the date and that table to load a flag, something like:

LET vMonthlyLoad = If(Num(WeekDay(Today())>=5 or Exists('HolidayDate',Date(Today(),'DateFormatOfHolidays') ,0 ,If(Month(ReloadTime())=Month(Today()) ,0 ,If(Day(Today()<10 ,0 ,1)));

I haven't tested so maybe there is some kind of error, the intention is:

- If today is is saturday, sunday or holiday -> don't load

- If the app has already being loaded this month -> don't load

- In other case, if day is above 10 -> load the app

So if 10 was saturday, 11 is sunday, 12 and 13 are holidays, then it will load on 14th, and on 15th it will not load because it has been already loaded this month on 14th.

Then after that just add:

IF $(vMonthLoad)=0 THEN Exit Script; ENDIF

And after this the rest of the script

Re: specific date

lennart_mo — Thu, 28 Aug 2025 11:54:02 GMT

Hi,

the method @rubenmarin suggested should work, the only problem I see, is that there'd be no data available after the Exit script statement, since the the script would've run successfully.

So you'd probably need to store all tables after reloads matching the criteria and load the data from those QVDs on all other loads.

Re: specific date

rubenmarin — Fri, 29 Aug 2025 06:26:47 GMT

True, I was thinking in a layer development, and that will be on the app that generates the data for the user app.

Re: specific date

Vegar — Fri, 29 Aug 2025 13:24:50 GMT

A way around this problem could be to use the app it self as a source during weekends and holidays

IF $(vMonthLoad)=0 THEN Binary LIB://reference_to_your_app; Exit Script; ENDIF

This will keep the data as is, and you won't have an issue with an empty app.

Another solution is to force an script error every time the weekday condition is not met. (I don't enjoy this solution my self, but I've seen it around.)

IF $(vMonthLoad)=0 THEN This row causes an error; ENDIF

Re: specific date

Manni_SM — Mon, 08 Sep 2025 07:29:17 GMT

thanks @Vegar @rubenmarin @lennart_mo it worked all your suggestions 🙂