Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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')
A quick fix to try:
CASE LENGTH Field={"<=10"}
i.e. - replace single quotes with double quotes. Search string in latest qlik works only with double quotes.