if condition not working

[sivarajs]

i am wondering why this simple expression is not working

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

this category is available. Any suggestion? Thanks

[sunny_talwar]

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

[PrashantSangle]

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

[Peter_Cammaert]

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

[sivarajs]

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

[Anil_Babu_Samineni]

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

[Peter_Cammaert]

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