Qlik Community

Ask a Question

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator III
Creator III

NPrinting Formula Help

Hello All -

I have an NPrinting issue that's driving me crazy.

In all of my Excel reports, I create a formula to give the date of the report:

='As of ' & Date(today(),'M/D/YY')

It's always worked until today. This time, it simply displays as the tag:

pay.PNG

The formula above it is similar:  ='For the week of ' &  Date(Cal.WeekStartMon,'M/D/YY') and it works. The number format on both cells is 'General'.

Any ideas what the heck is happening?

Thanks!

mike

1 Solution

Accepted Solutions
Specialist
Specialist

Does it give you the same result if you put your formula  in a different cell in your template?

Excel is very peculiar.  I can't tell you the number of times I have written formulas in Excel only to learn that the cell was formatted as text.  You have text in the two cells above it, so perhaps that is your answer.

View solution in original post

2 Replies
Specialist
Specialist

Does it give you the same result if you put your formula  in a different cell in your template?

Excel is very peculiar.  I can't tell you the number of times I have written formulas in Excel only to learn that the cell was formatted as text.  You have text in the two cells above it, so perhaps that is your answer.

View solution in original post

Creator III
Creator III

That worked... Thank you!!