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')
