Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Qlikuser09
Creator II
Creator II

Include a dimension value and exclude other dimension value in set analysis

Count({<workingFlag={1},[PTO]=-{'Y'}>}DISTINCT EmployeeCOunt)

I wanted to include working flag and Exclude Pto = Y , but the above seems to be not working

Labels (1)
2 Replies
RafaelBarrios
Partner - Specialist
Partner - Specialist

hi @Qlikuser09 

it would be helpfull if you paste a small set of data and what is the expected result.

Best,

 

 

vinieme12
Champion III
Champion III

you almost got it,. the - must be on the other side of the equal sign

as below

Count({<workingFlag={1},[PTO] -={'Y'}>}DISTINCT EmployeeCOunt)

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.