Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
If you are a Qlik Insight Bot user, join this collaborative group: JOIN GROUP
Contributor II

Average, % of Quota by all dimentions in Pivot Table

Hi frends!

Help me to write right expression to calculate "Quota" value by all dimentions.

Expression I'm using looks like:

Avg(

  Aggr(

  Sum ( TOTAL<Collection,Category,Group, Subgroup> Quota )

  ,Collection,Category,Group, Subgroup)

  )

I'm using pivot table:

5.png

Expression works fine on Subgroups level. But when we drill down to Group, Category and Collection it stops calculate AVG(...) rightly.

For example

Collection: April. If i drill down to Group i've got the next view:

6.png

If we look at Categorty: "Одежда (RTW)" and drill down to Category we need to get average "Quota" - 51,33 %.

But what we have:

2.png

???? It's wrong.

The same thing with Collection.

How to get average from the last granular lever "Subgroup" for all dimentions "Collection", "Category", "Group" ???

Or how to calculate the average as I wrote for example for Collection "April" and Category "Одежда (RTW)" - 51,33% ???

Please help! May be any advices?

P.S.: Source .qvw in attachment.

Thanks in advance.

1 Solution

Accepted Solutions
Highlighted
Not applicable

Re: Average, % of Quota by all dimentions in Pivot Table

Hi,

Why do you think, you should get 51,33%?

I feel 50, 68 is correct, as average happens within underlying data rather than just summing up 8 cells value and dividing it by 8.

Please let me know, if your requirement is different.

Thanks,

Vinod Kumar V

View solution in original post

1 Reply
Highlighted
Not applicable

Re: Average, % of Quota by all dimentions in Pivot Table

Hi,

Why do you think, you should get 51,33%?

I feel 50, 68 is correct, as average happens within underlying data rather than just summing up 8 cells value and dividing it by 8.

Please let me know, if your requirement is different.

Thanks,

Vinod Kumar V

View solution in original post