Sum of Average

[#1]

Hi All,

I need a solution for my scenerio given below:

I have a Dimension of Contact and it has 14 contacts, When I get Avg for the Dimension Contacts it gives me individual Avg for the Contacts and in last it gives % Avg.

Dimension Contact Avg

1 10%

2 2%

3 0

to

14 0

______

1%

The Avg gives me 1% in the total of Avg and is absolutely right. (Expression is sum(Ans) / sum(Tans) But I want sum of Average means 12 inplace of 1%. Secondly I want to divide Sum of Average which is 12 / 14 which are contacts.

How is this possible.

Urgent reply shall be highly appreciated.

Regards,

Khalid

[sparur]

Hello Khalid.

try use such expression:

sum(AGGR(sum(Ans) / sum(Tans), Contact))

[#3 · Accepted solution]

Many thanks,

Regards,

Khalid

[#4]

Hi,

Do you have any PDF or document regarding functions used in Qlikview.

Regards,

Khalid

[#5]

Dimension Contact Avg

Hi, I want to get 12% in the last of Avg but its giving 1%, is there any possibility to get 12% Avg in last.

Contacts Average

1 10%

2 2%

3 0

to

14 0

______

1%

Regards,

Khalid