If condition is need to verify

[#1]

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

[sunny_talwar]

Try this:

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

[sunny_talwar]

or

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

[#4]

Hi

i think you need to write nested if condition

[#5]

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

[swuehl]

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])

[#7]

Hi Sunny,

I modified like below..

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

Thanks,

Sub2u444

[sunny_talwar]

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

[sunny_talwar]

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

Anyways if you got what you were looking for, please close the thread by marking your or Stefan's answer as correct and mark any helpful answers

Best,

Sunny

[#10]

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‌