topic Re: Average Function To Include Nulls in QlikView

Average Function To Include Nulls

Fri, 21 Oct 2011 19:21:15 GMT

Is there a way in Qlikview to include the null dates to get the correct average?

8/1/2011	0
8/8/2011	0
8/15/2011	0
8/22/2011	0
8/29/2011	0
9/5/2011	0
9/12/2011	0
9/19/2011	0
9/26/2011	47
10/3/2011	54
10/10/2011	61
10/17/2011	68
Averge In Excel	19.16666667

Average In Qlikview 57.5

Re: Average Function To Include Nulls

its_anandrjs — Fri, 21 Oct 2011 19:29:49 GMT

Hi,

Average in qlikview is also correct how you calcualte it can you tell me.

See the attached sample file

HTH

Rgds

Anand

Average Function To Include Nulls

Fri, 21 Oct 2011 19:36:36 GMT

I attached the QVW, believe the issue is the nulls are being treated as text versus numbers.

Re: Average Function To Include Nulls

its_anandrjs — Fri, 21 Oct 2011 19:42:06 GMT

Hi,

Your application is not open on my side i think you use personal edition can you paste the code and dimension and expression details also.It will help full.

Rgds

Anand

Re: Average Function To Include Nulls

Fri, 21 Oct 2011 20:27:57 GMT

try this Sum(ColB)/count({$<ColB = {'>0'}>}ColB) to calculate the average.

Re: Average Function To Include Nulls

Fri, 21 Oct 2011 20:29:57 GMT

forgot to attach your qv doc.