Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

drillnaut
Valued Contributor

NPrinting 17 - Variable not updating

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:

BadHeader.PNG

But when I run a test report, I end up with this.

BadHeader2.PNG

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.

4 Replies
lech_miszkiewic
Honored Contributor III

Re: NPrinting 17 - Variable not updating

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

woutermak
Contributor III

Re: NPrinting 17 - Variable not updating

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.

lech_miszkiewic
Honored Contributor III

Re: NPrinting 17 - Variable not updating

Hi Wouter,

Justin is using Qlik Sense - so this is not a case with local/qvp connection

cheers

Lech

drillnaut
Valued Contributor

Re: NPrinting 17 - Variable not updating

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. 

Report1.PNG

Thanks for your help.

Community Browser