topic Re: Show expression if variable different from null in QlikView

Show expression if variable different from null

Anonymous — Wed, 19 Nov 2014 14:53:37 GMT

Hi,

i have created some variables on which I want an expression to be calculated. Now, I only want to show that expression in the chart if the variable is different from null (basically if i have selected some inputs for that variable). [ I actually have 10 variables that appear in the chart]

Which expression should i put in the Conditional field of the expression?

Re: Show expression if variable different from null

Or — Wed, 19 Nov 2014 15:02:04 GMT

Assuming both null() and blank string ( '' ) are considered empty, you can use:

Len(VariableName)>0

If you need it to explicitly be null, you should be fine with:

If(Isnull(VariableName),0,1)

Or something along those lines.

Good luck.

Re: Show expression if variable different from null

Wed, 19 Nov 2014 15:03:40 GMT

Try this:

if( len(variable) = 0, 'true')

Replace Variable with your variable name and replace 'True' with your expression.