topic Re: Mean Deviation in QlikView in Qlik Learning Discussions

Mean Deviation in QlikView

Wed, 10 Dec 2014 05:36:23 GMT

I have been trying to find the mean Absolute Deviation for each Account Contract. I have the following information and i have found the deviation for each user for each month in a pivot table. I also have their deviation from their mean for each value.

But my objective is to find the sum of all these deviations and divide it by the count of months to get the mean absolute deviation in a table where the only dimension is Account Contract. This is shown below:

Please help!

Re: Mean Deviation in QlikView

jonathandienst — Wed, 10 Dec 2014 05:40:59 GMT

Something like:

=Avg(Aggr(Fabs(Sum(Sales) - Avg(Total <Contract> Sales)), Month, Contract))

HTH

Jonathan

Re: Mean Deviation in QlikView

Wed, 10 Dec 2014 05:57:47 GMT

Yes Jonathan i have tried this also but the problem is this only works when i have selected a particular Contract and when i remove it from the selection and i want to see the complete information about all the customers, the data becomes erroneous.

When selected:

What i want:

I hope you get my point!

Re: Mean Deviation in QlikView

Wed, 10 Dec 2014 07:50:48 GMT

When selected:

What i want:

I hope you get my point!