Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Highlighted
lanlizgu
Contributor III

NPrinting Pixel Perfect format ∞ and NaN Values

In pixel perfect I have a situation on which I get ∞ and NaN values in NPrinting for a calculated field when I have nulls and zeros involved.

The think is that I would like not to show the ∞ and NaN values and just show an empty value as in other cells. I tried to change it in the expression without success.


Captura.JPG

What Can I do?

Thank you.

1 Solution

Accepted Solutions
Employee
Employee

Re: NPrinting Pixel Perfect format ∞ and NaN Values

Hi,

You could add an if statement that "surround" the formula so you can replace the result with the character you prefer in case of NaN or infinite.

If formula.png

Best Regards,

Ruggero

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
4 Replies
Employee
Employee

Re: NPrinting Pixel Perfect format ∞ and NaN Values

Hi,

You could add an if statement that "surround" the formula so you can replace the result with the character you prefer in case of NaN or infinite.

If formula.png

Best Regards,

Ruggero

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
lanlizgu
Contributor III

Re: NPrinting Pixel Perfect format ∞ and NaN Values

Thank you, I tried before without success, will try again and let you know.

lanlizgu
Contributor III

Re: NPrinting Pixel Perfect format ∞ and NaN Values

I was able to solve this with the following formula

Iif(

FORMULA

= '∞' or 'NaN'

, '' ,

FORMULA)

Thank you!

Employee
Employee

Re: NPrinting Pixel Perfect format ∞ and NaN Values

Great!

Thanks for sharing the correct formula; it will help other people.



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.