Avg Calculation in qlikview

[sat_tok52]

Hi Guru's,

I am calculating sum(Days) in my barchart it is showing the no of days 9 it is correct ,I want to calculate AVG of the days,I used Avg(Days) expression in my chart it still showing 9 but as per my requirement it should show 4.5.  Any help.

-Sateesh

[tresesco]

Could you post a demonstrative sample qvw? Or try, like:

Sum(Days)/Count(Total Days)

[jonathandienst]

Nulls are not considered in the Avg calculation. Therefore is is taking the average of the non-null values only. If you post your qvw or a representative sample, you will get specific help on how to work around this in your case.

[sat_tok52]

Hi Tresesco ,

Thanks for your quick reponse.

It's fine with out any selection , if I select Customer Name  A the sum(days) of customer is 9 ,I wanted to see the avg of Customer Name  A like 4.5 but it is showing still 9.

-Sateesh

[sat_tok52]

Thank you Jonathan,

Attached is the QVW.

Thanks,

Sateesh

[tresesco]

qvw is blank!

[sat_tok52]

Sorry..

Pls find the  attached 

[tresesco · Accepted solution]

Sum(Days)/Count(Total {<Name>}Days)

[tamilarasu]

Check the below expression

=Sum(Days)/Count(ALL Days)

[tamilarasu]

Tresesco,

If I add one extra field, I am getting wrong result .? What If I have more than 3 fields.?