Average Function To Include Nulls

[#1]

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

[its_anandrjs]

Hi,

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

See the attached sample file

HTH

Rgds

Anand

[#3]

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

[its_anandrjs]

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

[#5]

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

[#6 · Accepted solution]

forgot to attach your qv doc.