Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

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
Employee
Employee

Re: Nprinting Date

Hi Sikander,

Use Excel formatting.

HTH - Daniel.

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.

Employee
Employee

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.

Community Browser