Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

madeleine_josef
Contributor

KPI expression

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!

Tags (1)
1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: KPI expression

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


talk is cheap, supply exceeds demand
2 Replies
MVP & Luminary
MVP & Luminary

Re: KPI expression

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


talk is cheap, supply exceeds demand
MVP & Luminary
MVP & Luminary

Re: KPI expression

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