Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
How about:
=EmptyIsNull(Num(your expression), '0;0;'))
-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com
How about:
=EmptyIsNull(Num(your expression), '0;0;'))
-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com
Looking good! Thanks!