Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
I have a Qlik Sense Excel report that I'm sending out. I use a variable in the Sense Dashboard to set the header information. In the Sense dashboard, the header variable looks like this which is correct:
But when I run a test report, I end up with this.
Doing my due diligence, the Dashboard has been reloaded today ("5/22/2017") and the NPrinting report has been sent out today using the "Run Now" button.
Any help on why this variable seems to be a day behind no matter what is greatly appreciated.
Hi Justin?
Indeed it looks strange.
Are you using NPrinting 17.3.1 - If not - first thing i would do is proceed with upgrade to latest version.
Could you share how is this variable calculated? In script or in UI with "=" sign", Could you please share its formula so i can test on my end?
regards
Lech
Do you use a connection via QVP or a direct connection via local C:\....?
The last situation (local) can give you some cache problems. Use a QVP connection.
Hi Wouter,
Justin is using Qlik Sense - so this is not a case with local/qvp connection
cheers
Lech
Hello Lech,
1.) Yep, we are on NPrinting 17.3.0.0
2.) The variable is calculated in the script by this which I got with your help.
LET Today = timestamp(daystart(timestamp(today())) + maketime(6));
LET Yesterday = timestamp(daystart(timestamp(today()-1)) + maketime(6));
LET HeaderText = CHR(39)& 'On-Time Exception Report for '& '$(Yesterday)'&' to '&'$(Today)';
3.) In the Report, I have this.
Thanks for your help.