Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Count of an average in range

So I can do this in SQL with ease but set analysis is little more challenging.

Here's the situation.  I need to get a distinct count of countries with an average score in a range.

Table: Country(Name,Category,Score).  A country can have at most one score/category but there can be multiple categories/country

I've tried Count(<Avg(score), {>1,<2}>}Country).  I can get a count of scores in a range but the avg function shows a syntax error

Any thoughts?   Thanks.

3 Replies
sunny_talwar

May be this:

Count(DISTINT {<Country = {"=Avg(score) > 1 and Avg(Score) <2"}>} Country)

Not applicable
Author

Hmmm - I would need to indicate over which dimension to calculate the average.

I like the idea but it returns zero regardless of the range.

sunny_talwar

Would you be able to share a sample to show what exactly you are trying to do.