topic Re: Multiple if conditions in QlikView

Multiple if conditions

ferha_jafri — Fri, 23 Jun 2017 11:21:16 GMT

Hello Everyone,

Please help me I am stuck , I have a scenario in which I am using multiple if condition as

if(Sum(TO)>vTH,'Y',IF(Sum(TE)>vTH,N,if(Sum(TC)>vTH,Q,B))) so my problem is if the first condition is true it will not check second condition although I want to check all the conditions and return different values depending on the conditions.

Thank you

Ferha Sharma

Re: Multiple if conditions

sunny_talwar — Fri, 23 Jun 2017 11:23:36 GMT

Do you have few rows of sample data you can share and explain what you are looking to get?

Re: Multiple if conditions

ferha_jafri — Fri, 23 Jun 2017 11:52:58 GMT

If(sum(ABC)>vTh,'Value for ABC exceeds Thresh hold',if(sum(DEF)>vTh,'Value for DEFexceeds Thresh hold',if(sum(AO)>vTh,'Value for AO exceeds Thresh hold')))

Re: Multiple if conditions

sunny_talwar — Fri, 23 Jun 2017 12:40:36 GMT

Couple of questions

1) Is this needed in the script or front end?

2) What would this look like? 3 new columns?

Re: Multiple if conditions

ferha_jafri — Fri, 23 Jun 2017 12:46:18 GMT

This condition I have to place in mail alert message , but I want to know how it will check all the condition although the very first condition is true. so this is my main concern.

Re: Multiple if conditions

sunny_talwar — Fri, 23 Jun 2017 12:54:02 GMT

If it hits the true, the condition won't move forward... may you want something like this

If(sum(ABC)>vTh,'Value for ABC exceeds Thresh hold') & Chr(10)

If(sum(DEF)>vTh,'Value for DEFexceeds Thresh hold') & Chr(10)

If(sum(AO)>vTh,'Value for AO exceeds Thresh hold')

Now the above are three different conditions with there true values. It won't depend on the other condition being met.

Re: Multiple if conditions

zebhashmi — Fri, 23 Jun 2017 15:00:00 GMT

I think use if in result as well

if(Sum(TO)>vTH,'(IF(Sum..)',(IF(Sum(..)

Re: Multiple if conditions

ferha_jafri — Tue, 27 Jun 2017 05:50:40 GMT

Thank you Sunny