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: 
PARK_JY
Contributor III
Contributor III

COUNTIF(AVERAGE-StDev)

Hi,

I have a question.

1. I want to get the value in sheet.

ex)COUNT({$<A_FIELD={>=Avg(A_FILED)-StDev(A_FILED)}>} FIELD)

but, an error occurs.

Please let me know how to solve it.

thank you.

 

Labels (1)
1 Reply
barnabyd
Partner - Creator III
Partner - Creator III

G'day @PARK_JY,

I can see a couple of problems. Have a look at the Primer on Set Analysis by Henric. I think your expression is most similar to this one:

Sum( {$<Date={"<=$(=Max(Date))"}>} Sales)

So that suggests that your expression should be:

Count( {$<A_FIELD={">=$(=Avg(A_FIELD) - StDev(A_FIELD))"}>} FIELD )

(I have assumed that A_FILED should have been A_FIELD)

Cheers, Barnaby.

Barnaby Dunn
BI Consultant