Count if field greater than X but excluding other fields
Hi all,
In my set analysis, I'm trying to write a measure that counts the number of cases (Case ID Field) where the case length field is <= 10. However, I'm then trying to exclude cases where the Case Status field does not equal X and where the Case Type field does equal A.
I've had a go at the below and QlikSense tells me the formula is ok but it's returning a value of 0 which I know is incorrect! Can anyone please assist and tell me where I'm going wrong?! Thanks!
num( count(distinct {<CASE LENGTH Field={'<=10'}, Case Status Field-={'X'}, Case Type Field={'A'}>} Case ID Field), '#,##0')