Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to count a line in table, if a value is greater than a constant. I tried this:
Count(If(Compliance>0,74, [Typical Customer-Configuration Name]))
But it don't works
Hi @QlikSensor
It worked for me, the main difference is with you Compliance dimension, as it has decimal comma (,) instead of decimal point (.); I can't reconfigure my environment for the decimal comma; otherwise your expression is good (note, I abbreviated your columns names as you will find out.
NOTE: I used a table, are you using straight table?
Hope this helps,
And I tried another way (see screenshot), but the result is not as expected.
Hi @QlikSensor
It worked for me, the main difference is with you Compliance dimension, as it has decimal comma (,) instead of decimal point (.); I can't reconfigure my environment for the decimal comma; otherwise your expression is good (note, I abbreviated your columns names as you will find out.
NOTE: I used a table, are you using straight table?
Hope this helps,