Discussion board where members can get started with Qlik Sense.
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, targetsample1,1,3sample2,3,3sample3,4,3sample4,1,5sample5,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???
Go to Solution.
nice one Petter, so simple!
Worked perfectly, many thanks.