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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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.