Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Average Function To Include Nulls

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

8/1/20110
8/8/20110
8/15/20110
8/22/20110
8/29/20110
9/5/20110
9/12/20110
9/19/20110
9/26/201147
10/3/201154
10/10/201161
10/17/201168
Averge In Excel19.16666667

Average In Qlikview 57.5

1 Solution

Accepted Solutions
Not applicable
Author

forgot to attach your qv doc.

View solution in original post

5 Replies
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

Not applicable
Author

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

Not applicable
Author

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

Not applicable
Author

forgot to attach your qv doc.