Discussion Board for collaboration related to QlikView App Development.
I have to count ACTIVITY and then take its average. I am using this code
=Avg(Count(ACTIVITY)) but its not working.
Can Anyone help me with this.
See attached... Hope it helps
View solution in original post
Could you give a bit more details? An example qvw or a situation (with some data in a table) where we can see what you want? Average per....? year, week, month or per car, or per person? per ehhh??
Lets say it is activity per person and your table is like this
- person 1 day 1 activity 3 hours
- person 1 day 1 activity 5 hours
- person 2 day 1 activity 3 hours
and you'd like to have the average hours per person, then a chart with
- dimension person and
- expression like sum(activity) / count(person)
would give you the average activity per person
Does this help?
Avg(count(activity)) won't work as count(activity) just returns 2 and 1 in my example (per person) the average of that count would result in the same values too...
No I have Activity like
I have to find out how many activity is done per month.
Which I can find by COUNT(ACTIVITY), but I have to also find AVERAGRE Activity per month...
How can I do this?
Thanks It worked..
You can use the following expression also: