topic Re: If condition is need to verify in App Development

If condition is need to verify

Mon, 25 Apr 2016 10:17:52 GMT

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

sunny_talwar — Mon, 25 Apr 2016 10:20:20 GMT

Try this:

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

Re: If condition is need to verify

sunny_talwar — Mon, 25 Apr 2016 10:21:02 GMT

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

Re: If condition is need to verify

Mon, 25 Apr 2016 10:22:23 GMT

i think you need to write nested if condition

Re: If condition is need to verify

Mon, 25 Apr 2016 10:25:40 GMT

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

Re: If condition is need to verify

swuehl — Mon, 25 Apr 2016 10:26:33 GMT

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

Mon, 25 Apr 2016 10:27:01 GMT

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

sunny_talwar — Mon, 25 Apr 2016 10:35:23 GMT

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

Re: If condition is need to verify

sunny_talwar — Mon, 25 Apr 2016 10:38:45 GMT

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

Re: If condition is need to verify

Mon, 25 Apr 2016 12:01:00 GMT

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

Mon, 25 Apr 2016 12:01:34 GMT

Hi Sunny,

Requirement changed..

can you see below post..

Re: If condition is need to verify

sunny_talwar — Mon, 25 Apr 2016 12:09:46 GMT

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.