topic Count When (condition) in QlikView

Count When (condition)

Tue, 17 Apr 2012 14:37:34 GMT

Hi,

I have a problem in implementing the count function.

I am trying to insert an expression in a pivot table. The expression should return the count of glucose values for the glucose values which are less than 100.

I tried using: Count({$<Glucose={'<= 100)'}>}[Glucose])

Could someone help me out? Thanks in advance!

Count When (condition)

Tue, 17 Apr 2012 14:43:14 GMT

Try that : count ( { <Glucose <=100> } Glucose)

Count When (condition)

CELAMBARASAN — Tue, 17 Apr 2012 14:52:58 GMT

Hi,

Use double quotes for less than or greater than comparison,otherwise it take its whole <=100 to compare as text.

Count({$<Glucose={"<=100"}>}[Glucose])

Count({$<Glucose={<=100}>}[Glucose])

Celambarasan