topic Re: Multiple if conditions in expression in QlikView

Multiple if conditions in expression

Wed, 09 Jul 2014 07:47:55 GMT

Hello,

I am using the below expression in my chart to find out the Departments without any employees:

=Sum(Aggr(IF(Count(Distinct Employee ID)=0,1),Department))

What if I want to display the Departments without any employess for those whose city is 'NY' or ''LN' in the same chart?

Could anyone help me on this?

Thanks.

its_anandrjs — Wed, 09 Jul 2014 07:54:46 GMT

Try like if your expression works

=Sum({<city= {'NY', 'LN'} >} Aggr(IF(Count(Distinct Employee ID)=0,1),Department))

=Sum( if( Match(city,'NY', 'LN'), Aggr(IF(Count(Distinct Employee ID)=0,1),Department)))

Wed, 09 Jul 2014 10:40:27 GMT

Thanks Anand.

I am trying to use it in this set analysis expression but geting error.

=count({<DEPT_ID=e({<EMP_ID={*}>}DEPT_ID)>})

Could you guide me on how to use it?

Wed, 09 Jul 2014 11:22:03 GMT

I tried this but getting incorrect results.

=count({<DEPT_ID=e({<E_ID={*},city={'NY','LN'}>}DEPT_ID)>}DEPT_ID)

sasikanth — Wed, 09 Jul 2014 11:39:01 GMT

try Some thing like below

=count({<EMP_ID={'0'},ciry={'*'}-{'NY','LN'}>}DEPT_ID)

count({<City={'*'}-{'NY','LN'}>} if(isNull(EMP_ID),DEPT_ID))

Wed, 09 Jul 2014 11:43:49 GMT

Hi, try this below expression it might helps you

=Count({<city= {'NY', 'LN'}, E_ID={"=(Count(E_ID)=0)"}>} DEPT_ID)

Regards,

Satish

Wed, 09 Jul 2014 13:32:29 GMT

I tried all the above combinations but its still not working for me

its_anandrjs — Fri, 11 Jul 2014 19:22:36 GMT

Sorry for late response busy for some urgent works let me know what is your expected output. If have a data then provide please.

Mon, 14 Jul 2014 12:51:11 GMT

Thanks, I got it now.