topic Re: Using QlikView Variables in NPrinting (Sept 2018) output file names in Qlik NPrinting

Using QlikView Variables in NPrinting (Sept 2018) output file names

kdmarkee — Wed, 04 Dec 2019 21:19:09 GMT

I need some help with how I should be setting up the code in my QlikView app for a date variable so that when I use that variable in the output file name of an NPrinting report, it comes out as a date. I want to use the highlighted variable in my NP output file name as shown below...

My QV logic looks like this right now:

set vAccountingDate = Date([MonthEnd.Accounting Date], 'M/D/YYYY');
set vNPAccountingDate = $(vAccountingDate);

$(vNPAccountingDate) works fine in QV app but when used in NP it comes out like this (I want the red text to be the date): Fusion Month End Report_Date([MonthEnd.Accounting Date], 'M_D_YYYY')_KMark (999-224).pdf

Thanks for you help.

Re: Using QlikView Variables in NPrinting (Sept 2018) output file names

sunny_talwar — Tue, 05 Feb 2019 15:48:45 GMT

Can you try this

SET vAccountingDate = '=Date([MonthEnd.Accounting Date], ''M/D/YYYY'')';

Re: Using QlikView Variables in NPrinting (Sept 2018) output file names

sunny_talwar — Tue, 05 Feb 2019 15:49:34 GMT

And then use vAccountingDate in nPrinting

Re: Using QlikView Variables in NPrinting (Sept 2018) output file names

kdmarkee — Tue, 05 Feb 2019 16:15:05 GMT

Thank you for your quick response. I will try this and let you know how it works; the report runs awhile.

Re: Using QlikView Variables in NPrinting (Sept 2018) output file names

pradosh_thakur — Tue, 05 Feb 2019 16:20:27 GMT

Else you can just change set to Let.

Re: Using QlikView Variables in NPrinting (Sept 2018) output file names

kdmarkee — Tue, 05 Feb 2019 17:46:34 GMT

That worked, thanks again.