topic Re: Avg(Sales) in QlikView

Avg(Sales)

kalyandg — Fri, 09 Nov 2012 10:33:00 GMT

How to Calculate Avg of Sales. I have a data for two years, but my requirement is i should calculate avg(sales)

If selection is Current year - 3^rd month then take average of 12 months in last year + upto Cur. Year 3^rd month = Total 15 months sales average

Please help me to solve this issue, with a briefed expression.

Wed, 14 Nov 2012 06:39:29 GMT

Hai Kalyan,

Pls send the datin the form of excel

Regards,

Chandu

Wed, 14 Nov 2012 06:50:22 GMT

Hi Sundaram

As far as I understood you requirement you could use the following expression with set analysis.

Avg ({1<Date= {'>=$(min({1<Year ={$(=Year-1)}>} Date))<=$(vMax)'}>}Sales) ===

Avg ({1<Date= {'>=$(Previous year min date)<=$(Current month Max date)'}>}Sales)

Attached is a sample QVW

Hope this solves. I have assumed the way you data looks. If you have any specific requirements do let me know.

Thanks

fahad

jagan — Wed, 14 Nov 2012 08:19:56 GMT

Hi,

Try this

=Sum({<DateFieldName={'>=$(=YearStart(Max(DateFieldName), -1))<=$(=Max(DateFieldName))'}>}Sales)/RangeSum(12 + Num(Month( Max(DateFieldName))))

Hope this helps you.

Regards,

Jagan.

kalyandg — Wed, 14 Nov 2012 09:06:06 GMT

Hi jagan,

Thank you, its working

kalyandg — Wed, 14 Nov 2012 09:06:55 GMT

Hi fahad,

Thank you very much, its working and i am very clear now

kalyandg — Wed, 14 Nov 2012 09:11:15 GMT

hi fahad,

i have to use both expression or any one

Wed, 14 Nov 2012 09:40:33 GMT

Hi Kalyan

You have to use the first expression.

Second is just an illustration.

Thanks

Fahad