topic Re: Nprinting Date in Qlik NPrinting

Nprinting Date

sikander02 — Tue, 14 Mar 2017 15:13:42 GMT

Hi ,

I am really new to Nprinting and this is the first report I am trying to build and having trouble in using a variable in Excel sheet

I created the variable which gives us yesterdays date, works fine in QVW but if I am trying to use same variable in Nprinting excel sheet it give me value in Number format, earlieare I used it in subject line of messages worked fine. I even tried formatting it in formula

while putting the formula, Formula result gives me desired result, but once I put this formula on sheet gives me same result as the putting the variable on sheet

Thanks

Re: Nprinting Date

Daniel_Jenkins — Wed, 15 Mar 2017 00:38:22 GMT

Hi Sikander,

Use Excel formatting.

HTH - Daniel.

Re: Nprinting Date

sikander02 — Wed, 15 Mar 2017 02:32:36 GMT

Thanks Daniel,

I actually did it in Qlikview, created a second variable in QVW where I am converting it into text now it give me correct value. But I am not sure if this is the correct way.

Thank you once again.

Re: Nprinting Date

Daniel_Jenkins — Wed, 15 Mar 2017 21:05:03 GMT

Hi Sikander,

Yes, you have choices. Any way that works for you would be the 'correct' way in my opinion

HTH - Daniel.