Solved: Count a table line if a certain value in that line... - Qlik Community

QlikSensor · ‎2020-05-11

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

ArnadoSandoval · ‎2020-05-11

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,

Arnaldo Sandoval
A journey of a thousand miles begins with a single step.

View solution in original post

QlikSensor · ‎2020-05-11

And I tried another way (see screenshot), but the result is not as expected.

ArnadoSandoval · ‎2020-05-11

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,

Arnaldo Sandoval
A journey of a thousand miles begins with a single step.

Count a table line if a certain value in that line is greater than a constant