topic Re: if condition not working in QlikView

if condition not working

sivarajs — Thu, 11 May 2017 12:46:13 GMT

i am wondering why this simple expression is not working

if(category='NSAs',1,0)

this category is available. Any suggestion? Thanks

Re: if condition not working

sunny_talwar — Thu, 11 May 2017 12:47:28 GMT

Where are you carrying this out? Script or front end?

Re: if condition not working

PrashantSangle — Thu, 11 May 2017 12:48:50 GMT

Hi,

it is might be because of space or case sensitive.

use wildmatch() or match()

like below

if(wildmatch(trim(category),'NSAs'),1,0)

Regards

Re: if condition not working

Peter_Cammaert — Thu, 11 May 2017 12:56:58 GMT

What do you mean by "not working"? Is it returning nothing at all? Or just the wrong values? Or always the same value?

Do not use this code as a chart expression. Because of the possible aggregation of rows, field category may carry multiple values. Even if you cannot see some of them...

Re: if condition not working

sivarajs — Thu, 11 May 2017 13:07:20 GMT

Condition fails shows 0 always but the values in the category exist

Re: if condition not working

Anil_Babu_Samineni — Thu, 11 May 2017 13:17:59 GMT

Are you sure, The category has same Name NSAs. Because, If condition consider as Case Sensitive. Could be the case, You have only one which the value

Or else you may explain more on this

Re: if condition not working

Peter_Cammaert — Thu, 11 May 2017 13:18:15 GMT

What you can do is try the following:

create a listbox with field category
add an expression to this listbox (see ListBox properties->Expressions) and enter your =IF(...) code in the expression field.
tune the IF(...) call expression (see previous examples) until your code works as expected.

Best,

Peter