Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Variables returning either numeric or text value

Hi All,

Have been able to define a number of variables.

When using predefined numeric values, I am able to extract this value and evaluate it appropriately.

HOWEVER, when using text values as a pre-defined list, I am unable to evaluate whether a particular condition has been met.

Please see attached file for clarification...

Anyone have any ideas?

Please advise,

Kind regards,

Rich

1 Solution

Accepted Solutions
Miguel_Angel_Baeyens

Hello Rich,

When the variable stores a literal string, it doesn't need to evaluate it, so you can call it without expanding.

=if(zz_Display='Annual',100,0)


Hope that helps.

View solution in original post

1 Reply
Miguel_Angel_Baeyens

Hello Rich,

When the variable stores a literal string, it doesn't need to evaluate it, so you can call it without expanding.

=if(zz_Display='Annual',100,0)


Hope that helps.