Convert Zero to Nulls in UI measure

[Amit_B]

Hi all,

Is it possible to convert zeros into Nulls as a calculation result of a measure?

For example,
The second measure (in purple) get 0 in 2024-01 to 2024-03, so the first value should be in April.
I made it with If function but it's less convenient in complex measures.
It didn't work if I just uncheck 'Include Zero Values'.
I'm looking for a function like Alt that can convert the Nulls to Zero.

Thanks!

[rwunderlich · Accepted solution]

How about:

=EmptyIsNull(Num(your expression), '0;0;'))

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

[Amit_B]

Looking good! Thanks!