Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Tx
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.
Try this:
if( len(variable) = 0, 'true')
Replace Variable with your variable name and replace 'True' with your expression.