topic Re: expression help in QlikView

expression help

Wed, 08 Oct 2014 16:39:36 GMT

I am looking at one of the example somewhere was trying to figure out the below expression

=if(0 = $(variable), ' - ', $(variable))

What does this mean?

Clever_Anjos — Wed, 08 Oct 2014 16:48:39 GMT

It variable contains 0 value, it should return "-", otherwise, variable value

JonnyPoole — Wed, 08 Oct 2014 20:30:57 GMT

Its showing the value that the variable equals, with one minor exception in that if its 0 then show as '-'

A-> A

B-> B

C-> C

0-> -