Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
What Can I do?
Thank you.
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.
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.
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.
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.
Thank you, I tried before without success, will try again and let you know.
I was able to solve this with the following formula
Iif(
FORMULA
= '∞' or 'NaN'
, '' ,
FORMULA)
Thank you!
Great!
Thanks for sharing the correct formula; it will help other people.