11 Replies Latest reply: Apr 25, 2016 8:09 AM by Sunny Talwar

# If condition is need to verify

Hi Folks,

I wrote like this in IF condition at Qlik Sense. It's not working.

Can any one check and modify..

=If([Customer Impact]<>('Medium','Low'),[Customer Impact])

Regards,

Sub2u444

• ###### Re: If condition is need to verify

Try this:

=If(not Match([Customer Impact], 'Medium', 'Low'), [Customer Impact])

• ###### Re: If condition is need to verify

or

=If([Customer Impact] <> 'Medium' or [Customer Impact] <> 'Low', [Customer Impact])

• ###### Re: If condition is need to verify

Hi Sunny,

I modified like below..

If([Customer Impact] <> 'Medium' and [Customer Impact] <> 'Low', [Customer Impact])

Thanks,

Sub2u444

• ###### Re: If condition is need to verify

Ya right because we are using not equal logic, it should be AND and not OR

• ###### Re: If condition is need to verify

This one is not working Sunny. Let me check with below one.

• ###### Re: If condition is need to verify

Are you sure this did not work? I would think that this would work as well.

Best,

Sunny

• ###### Re: If condition is need to verify

Hi Sunny,

Requirement changed..

can you see below post..

• ###### Re: If condition is need to verify

Hi

i think you need to write nested if condition

• ###### Re: If condition is need to verify

In which context are you using this expression? In a calculated dimension?

Either use If(not Match([Customer Impact], 'Medium', 'Low'), [Customer Impact]) as shown above, or

=If([Customer Impact] <> 'Medium' AND [Customer Impact] <> 'Low', [Customer Impact])

• ###### Re: If condition is need to verify

Hi,

Sorry all..

my requirement changed....

I have a Status Filter in that values are - "Safety,Critical,High,Medium,Low"

Default i should show "Safety,Critical,Hot", other wise i should show 5 values.

any one can help with the expr...

sub2u444

• ###### Re: If condition is need to verify

Otherwise show 5 values? What do you mean by that?

Also I recommend creating new thread for a new/changed requirement as it becomes difficult for people to look for correct answers in the future.