KPI expression

[Anonymous]

Hi,

I would like to create a KPI that uses my value 'claimed' but QlikSense will not let me use the following expression. Can you please help to correct it?

RangeSum(Count({<claimed > {1}>} AssignmentNo))/Count(AssignmentNo)

I want the KPI to count how many of the assignments that have a claimed value higher than or equal to 1.

Thanks!

[Gysbert_Wassenaar · Accepted solution]

Try this: Count({<claimed = {'>=1'} >} AssignmentNo)/Count(AssignmentNo)

[rbecher]

Btw. this should be double quotes: {">=1"}