Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
forgot to attach your qv doc.
Hi,
Average in qlikview is also correct how you calcualte it can you tell me.
See the attached sample file
HTH
Rgds
Anand
I attached the QVW, believe the issue is the nulls are being treated as text versus numbers.
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
try this Sum(ColB)/count({$<ColB = {'>0'}>}ColB) to calculate the average.
forgot to attach your qv doc.