QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for
Did you mean:  Contributor

Average count of subgroups

Hi All,

I was hoping to get some help on the below which I cannot seem to find a solution for.

I need to create a chart which counts the average number of items per group/ sub-group, and also the deviation away from the average for each number in the sub-group.

Basically I am trying to calculate the mean/ average count of items per dimension group (the columns in yellow are where I need the help).

In the below example:

How to count number of sub-groups per Group

How to calculate average # of items in each Group.

Next step will be to calculate the deviation from the average for each Group

I assume I will need the aggr function, but I have little experience with Aggr and I am struggling to see how to apply the formula.

Many thanks! 1 Solution

Accepted Solutions  MVP

May be this

 How to count number of sub-groups per Group

Count(DISTINCT TOTAL <Group> Sub-Group)

 How to calculate average # of items in each Group.

Avg(TOTAL <Group> Aggr(Count(Items), Group, [Sub-Group]))

Stdev will be like this

Stdev(TOTAL <Group> Aggr(Count(Items), Group, [Sub-Group]))

2 Replies  MVP

May be this

 How to count number of sub-groups per Group

Count(DISTINCT TOTAL <Group> Sub-Group)

 How to calculate average # of items in each Group.

Avg(TOTAL <Group> Aggr(Count(Items), Group, [Sub-Group]))

Stdev will be like this

Stdev(TOTAL <Group> Aggr(Count(Items), Group, [Sub-Group]))  Contributor
Author

Thanks - that was extremely helpful. Community Browser