Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

NPrinting Numbers are shown as text

I have a calculation that were already done in qlik sense, but when i add it to NPrinting it converts to text, although i unchecked the Keep Source Format, and i formatted the cells as numbers, and i tried the function NUM() in qlik sense and still I'm getting it as text.

What is the problem and how can i solve it?

Thanks,

1 Solution

Accepted Solutions
Highlighted
Contributor III
Contributor III

in Qlik Sense change the field formatting to number, this should work out.

View solution in original post

3 Replies
Highlighted
Creator III
Creator III

Hi,

I do not have np 17 to test it but I think it is the same problem as in 16.

Depending on where you have the problem:

If it is expression then change the format in chart properties -> Number (integer or fixed decimals).

If it is dimension then instead of Num() change the format in Document properties -> Number format.

BR,

  Matus

Highlighted
Contributor III
Contributor III

in Qlik Sense change the field formatting to number, this should work out.

View solution in original post

Highlighted
Specialist
Specialist

Thanks, learn new stuff!!!

All the input field format can be setted in Document properties. That is really great!!

But it still does not work for my case. The table I use in nprinting is a pivot table. The dimension with number format is  "General" format in the generated excel report.

Is that a limitation of using pivot table?

Zhihong