topic AW:Re: IF Question in QlikView

IF Question

Tue, 06 Apr 2010 13:05:37 GMT

Hi,

has someone an idea how I can handle something like this:

if(category = '1' OR category '2', 'all', if(category='2', 'only 2')) AS categoryclass

thanks

Aloah

IF Question

Tue, 06 Apr 2010 13:18:21 GMT

Please key in your question with some explanations to what you need..

AW:Re: IF Question

brenner_martina — Tue, 06 Apr 2010 13:43:27 GMT

Hello,

What about that Condition:

If(category='2',If(category = '1', 'all', 'only 2')) AS categoryclass

AW:Re: IF Question

Tue, 06 Apr 2010 14:43:30 GMT

In your data can a single record have more than a single value the field category? Understanding the potential values of the field will help suggest the correct syntax of your conditional statement.

/emb

AW:Re: AW:Re: IF Question

brenner_martina — Tue, 06 Apr 2010 15:08:37 GMT

Pardon, there is the bracket wrong:

If(category='2',If(category = '1', 'all'), 'only 2') AS categoryclass