Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

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

11 Replies
MVP
MVP

Re: If condition is need to verify

Try this:

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

MVP
MVP

Re: If condition is need to verify

or

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

Not applicable

Re: If condition is need to verify

Hi

i think you need to write nested if condition

Not applicable

Re: If condition is need to verify

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

MVP
MVP

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

Not applicable

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

MVP
MVP

Re: If condition is need to verify

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

MVP
MVP

Re: If condition is need to verify

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

Not applicable

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

Community Browser