Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
SatyaPaleti
Creator III
Creator III

How to use AND & OR condition in Qliksense set analysis

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

 

 

Labels (1)
3 Replies
Chanty4u
MVP
MVP

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
Creator III
Creator III
Author

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

Chanty4u
MVP
MVP

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.