topic Re: Avg Calculation in qlikview in QlikView

Avg Calculation in qlikview

sat_tok52 — Tue, 01 Mar 2016 04:23:51 GMT

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

Re: Avg Calculation in qlikview

tresB — Tue, 01 Mar 2016 04:42:31 GMT

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

Sum(Days)/Count(Total Days)

Re: Avg Calculation in qlikview

jonathandienst — Tue, 01 Mar 2016 04:46:50 GMT

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.

Re: Avg Calculation in qlikview

sat_tok52 — Tue, 01 Mar 2016 05:02:06 GMT

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

Re: Avg Calculation in qlikview

sat_tok52 — Tue, 01 Mar 2016 05:12:07 GMT

Thank you Jonathan,

Attached is the QVW.

Thanks,

Sateesh

Re: Avg Calculation in qlikview

tresB — Tue, 01 Mar 2016 05:15:03 GMT

qvw is blank!

Re: Avg Calculation in qlikview

sat_tok52 — Tue, 01 Mar 2016 07:29:21 GMT

Sorry..

Pls find the attached

Re: Avg Calculation in qlikview

tresB — Tue, 01 Mar 2016 07:34:27 GMT

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

Re: Avg Calculation in qlikview

tamilarasu — Tue, 01 Mar 2016 07:35:31 GMT

Check the below expression

=Sum(Days)/Count(ALL Days)

Re: Avg Calculation in qlikview

tamilarasu — Tue, 01 Mar 2016 07:44:59 GMT

Tresesco,

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

Re: Avg Calculation in qlikview

tresB — Tue, 01 Mar 2016 07:57:02 GMT

That is up to how the user is expecting the output to behave. Since, Name is there in the dimension, usually user would expect only the Name field's selection to be disregarded. I.e. - avg result should be sensitive to other selections. Otherwise, if all selections are expected to be disregarded(which is normally not expected), yours is the way to go with.

Re: Avg Calculation in qlikview

tamilarasu — Tue, 01 Mar 2016 08:05:34 GMT

Thanks