Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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
MVP
MVP

Variables returning either numeric or text value

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.

1 Reply
MVP
MVP

Variables returning either numeric or text value

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.

Community Browser