How to use AND & OR condition in Qliksense set analysis

[SatyaPaleti]

Hi Friends,

How to use AND condition and OR condition inn qliksense set analysis

for example: 

I have below requirement.

I need to show count of Employee ID's where

• Employee Department is YTC AND
• Employee Location is Florida AND
• Employee Account Type is Acceptable OR
• Employee Salary Account is Saving OR
• Employee Job Type is Permanent

I have to write a condition in set analysis by satisfying all these conditions.  I am writing below condition but im not getting exact result

= Count({<Emp.Dept = {YTC}, Emp.Loc = {'Florida'}>+ <Emp.Accttype = {'Acceptable'}, Emp.SalaryType = {'Savings'}, Emp.Jobtype = {'Permenant'}> }Emp.ID)

Can some one please help me to fix this Issue

Thanks,

Satya

[Chanty4u]

its looks correct only..

did you miss single quotes for YTC?

= Count({<Emp.Dept = {'YTC'}, Emp.Loc = {'Florida'}>+ <Emp.Accttype = {'Acceptable'}, Emp.SalaryType = {'Savings'}, Emp.Jobtype = {'Permenant'}> }Emp.ID)

[SatyaPaleti]

   Thank you Chanty for response on this. No I am not missing any quotes

[Chanty4u]

looks like expression is correct.   what is your expected count? and how much you are getting?

can you attach sample?

or try like below.

remove all conditions   just use count( distinct id)     and add all others filters in filterpane and select one by one and see the result.

or

add one by one condition and check where exactly its going wrong.