Variable Expression Help

Tue, 23 Jul 2013 14:29:01 GMT

I am trying to write the following variable but it is not working. I am trying add the part about PTGradeBanded=PT to the Category section but it give me no results. Any help is appreciated.

=If(var_selection_visible='0',PTGradeBanded={'PT'},'Category',IF(var_selection_visible='1','PTGradeBanded'))

Re: Variable Expression Help

swuehl — Tue, 23 Jul 2013 15:02:53 GMT

I am trying add the part about PTGradeBanded=PT to the Category section but it give me no results. Any help is appreciated.
=If(var_selection_visible='0',PTGradeBanded={'PT'},'Category',IF(var_selection_visible='1','PTGradeBanded'))

Sorry, I do not understand. You are trying to define a variable (what's its name?) in variable overview, right?

And you want to assign a value based on another variable var_selection_visible, right?

So, when var_selection_visible = '0', what value do you want to assign?

When var_selection_visible = '1', what value do you want to assign?

Any other condition?

topic Variable Expression Help in QlikView

Variable Expression Help

Re: Variable Expression Help