How to ignore a field value in IF Expression

[Pulkit_Thukral]

Hi All,

I am having problem in writing an expression that would ignore a particular field value .

Basically , In Set Analysis like we write   = {<Field_name= >}

The same kind of expression I want in  IF Expression ==????

Thanks in advance

[qlikmsg4u]

Something like this

=If(Field_name <> 'Value',Condition)

[puttemans]

Hi,

Would look like :

IF ( Field_name <> 'your particular value', do A, do B)

where the commas stand for 'then' and 'else'.

It is possible to combine statements, so you can de IF(Field_name <> 'your particular value', IF(Field_name = y, do A1, do A2), do B).

Regards,

Johan

[jonathandienst]

I assume that you want to ignore a field selection rather than a field value?

If that is the case, then the set expression is the only way.

Note that in many cases you want to use a set expression rather than a sum(if()) type of construct anyway - the sum(if()) can perform badly on a large data set.

[svinnakota]

Hi Pulkit,

If you resolved that issue, can you please share that expression with us how did you use the excluding value in the if condition.

Thanks,

Santosh Aravind.