Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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!

1 Solution

Accepted Solutions
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
rbecher
MVP
MVP

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

Astrato.io Head of R&D