Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
pokermon
Not applicable

count function in kpi

Hi all,

Apologies for the noobness of the questions...but...I have loaded the following sample data. I'd like to use a KPI to show how many of the 5 lines of data are underperforming, on target and over performing

data:
load * Inline [
sample, actual, target
sample1,1,3
sample2,3,3
sample3,4,3
sample4,1,5
sample5,3,3

];

the expression I would use is along the lines of

count(actual<target)     for under performing

count(actual=target)     for on target

count(actual>target)     for over performing

what is the correct syntax for these queries please???

thanks,

Pokes

1 Solution

Accepted Solutions
petter
Not applicable

Re: count function in kpi

2017-03-10 00_13_12-Qlik Sense Desktop.png

3 Replies
petter
Not applicable

Re: count function in kpi

2017-03-10 00_13_12-Qlik Sense Desktop.png

PVS
Not applicable

Re: count function in kpi

nice one Petter, so simple!

pokermon
Not applicable

Re: count function in kpi

Hi Petter,

Worked perfectly, many thanks.

Pokes