Multiple if conditions in expression

[#1]

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]

Try like if your expression works

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

Or

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

[#3]

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?

[#4]

I tried this but getting incorrect results.

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

[sasikanth]

HI

try Some thing like below

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

or

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

[#6]

Hi, try this below expression it might helps you

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

Regards,

Satish

[#7]

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

[its_anandrjs]

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

[#9]

Thanks, I got it now.