Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have the following scenario. Please refer the attached snapshot.
I need to replace the Yellow color cells to ZERO (0).
I need you guys help hand in achieving this in "QlikSense".
Thanks in advance
It's a little difficult to determine exactly where you're trying to use this. Is it in a pivot table or standard table? If so then I assume you've got something like
Sum(Value) as the measure and you're saying if that's null then make it zero?
If that's what your'e trying to do then try this.
If(IsNull(Sum(Value)), 0, Sum(Value))
If that's not what you're trying to do then please post an example.
I hope this helps.