topic AVG? in QlikView

AVG?

Anonymous — Mon, 30 Mar 2015 18:15:20 GMT

sum({<Y=,Monthnum=>}Sales)/Count( DISTINCT Monthnum)

when i am trying calculate it is not giving avg

here Count( DISTINCT Monthnum) is 06

if i give manually 06 then it is giving avg if i write Count( DISTINCT Monthnum) its not giving avg

its giving only sum(sales)

what is the mistake here ?

ramoncova06 — Mon, 30 Mar 2015 19:00:33 GMT

it most likely related with the fact that you are ignoring the MonthNum in you first set analysis,trying creating this in a variable

Anonymous — Mon, 30 Mar 2015 19:22:08 GMT

Is Monthnum a correct field name? What if you try this in a text box:

Count( DISTINCT Monthnum)

Tue, 31 Mar 2015 06:06:11 GMT

cAN YOU SHARE YOUR SAMPLE FILE?

Tue, 31 Mar 2015 08:06:00 GMT

Hi,

If sum({<Y=,Monthnum=>}Sales)/Count( DISTINCT Monthnum) gives you sum({<Y=,Monthnum=>}Sales) its because Count( DISTINCT Monthnum) = 1.

If Count( DISTINCT Monthnum)=1 its because you have only one monthnum.

Have you selected a month ?

Is Monthnum the correct field ?

Maybe have you forgotten the set analysis in the second aggregation. Try this :

sum({<Y=,Monthnum=>}Sales)/Count({<Y=,Monthnum=>}DISTINCT Monthnum)