topic Average expressions in QlikView

Average expressions

Mon, 21 Jan 2013 10:09:01 GMT

hi ,

I have to calculate average for selected number of zones. If i select single zone it will display the correct value, but if i select two to three zones , it is not showing the correct value. Please help me with the expressions.

Thanks in advance

Re: Average expressions

swuehl — Mon, 21 Jan 2013 10:20:34 GMT

It is hard to answer your request, because we don't know anything about the expression you are using, the data model, the context.

Could you post a small qvw sample file here to the forum? And your requested result?

Or some lines of your data as INLINE table?

Re: Average expressions

Mon, 21 Jan 2013 10:35:18 GMT

"Avg

({$< Year = {"<=$(#vYear)"}>}[ Annual Average]) "

where annual average values are -28.91 -28.27 & 25.48

Answer should be -10.56 . But it is displaying -16.

Re: Average expressions

swuehl — Mon, 21 Jan 2013 10:46:17 GMT

Have you checked the number of records that avg() uses, i.e. the frequency of your [Annual Average] values?

Try using

count({$< Year = {"<=$(#vYear)"}>}[ Annual Average])

Do you get 3 for your sample?

Re: Average expressions

Mon, 21 Jan 2013 11:06:10 GMT

Yes i did. I checked the frequency, Its more .

I used DISTINCT in the same expression & got correct answer. Thanks for your clue