Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
hi @Qlikuser09
it would be helpfull if you paste a small set of data and what is the expected result.
Best,
you almost got it,. the - must be on the other side of the equal sign
as below
Count({<workingFlag={1},[PTO] -={'Y'}>}DISTINCT EmployeeCOunt)