topic Re: Absolute Average in QlikView

Absolute Average

Thu, 30 May 2013 05:55:47 GMT

Hi All,

I need Help, Requirement is we looking for absolute Average. Case is that suppose a customer the product every month.for example customer sell the Product in April,June ,July and August then you want to find out the average .So logic is that for the Average is you have to consider the month may also for finding the average.

Any help would be appreciated.

Thanks in advance.

Regards

Deepak

Re: Absolute Average

Gysbert_Wassenaar — Thu, 30 May 2013 06:03:14 GMT

Something like this: sum(Sales)/(max(month)-min(month)). If you don't have a numeric month field you'll have to create one. If you have a salesdate then calculating it in the script is the easiest way to create it: month(salesdate) as month

Re: Absolute Average

Thu, 30 May 2013 07:15:09 GMT

Hi Gysbert,

Thanks for Reply. but scenario is that Suppose in 2012-13, Customer is created in June ,Invoice is generated or delivered in the Aug,Sept,Oct,Dec. I want to show the Absolute Average from June to Dec.i.e Sum(dispathchQty)/no of months(June-dec).

Please Give me sum Idea.

Regards

Deepak