Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Sikander,
Use Excel formatting.
HTH - Daniel.
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.
Hi Sikander,
Yes, you have choices. Any way that works for you would be the 'correct' way in my opinion
HTH - Daniel.