Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
sikander02
New Contributor III

Nprinting Date

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


nprinting.PNG

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

nprinting.PNG

nprinting.PNG

Thanks

3 Replies
Support
Support

Re: Nprinting Date

Hi Sikander,

Use Excel formatting.

HTH - Daniel.

Highlighted
sikander02
New Contributor III

Re: Nprinting Date

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.

Support
Support

Re: Nprinting Date

Hi Sikander,

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

HTH - Daniel.