topic Re: Variable misbehaved once in Qlik NPrinting

Variable misbehaved once

Lauri — Mon, 03 Jun 2024 16:39:25 GMT

I have an NPrinting report that runs every Sunday morning. It's been working perfectly for a few months - until yesterday. The report name includes a variable from Sense that evaluates this:

=date(WeekStart(Today()), 'YYYY.MM.DD')

The report setup:

Every week, the report has gotten the correct name. Yesterday, the report ran as usual BUT the file name contained 2024.05.26 instead of 2024.06.02 (yesterday's date).

Any ideas why?

I could change the variable to =date(Today(), 'YYYY.MM.DD') but it's not ideal because sometimes the report needs to run on other days.

Re: Variable misbehaved once

Lech_Miszkiewicz — Mon, 03 Jun 2024 19:35:56 GMT

Hi @Lauri

It is not possible to tell why it shown different date without investigating. First you would need to check your Qlik Sense app as well as the variable value returned for that variable (preferably at the time when you generated report).

Re: Variable misbehaved once

marcus_sommer — Tue, 04 Jun 2024 10:56:16 GMT

It might be related to the timer_mode of today() and the time of the last reload: today - script and chart function | Qlik Cloud Help

Re: Variable misbehaved once

Lauri — Mon, 10 Jun 2024 14:49:48 GMT

Thank you for your ideas. The timer_mode is good to know about. I don't provide a value for that parameter, so I assume the default (1 - the date of the function call) will return the date of the day NPrinting runs the report. Even if it somehow returned the date the app reloaded, then I should see the problem every week, because the app never reloads on Sunday (which is the start of the week in our environment).