topic STD Deviation from an AGGR function. in QlikView

STD Deviation from an AGGR function.

LeeSmithBtn — Thu, 02 Jan 2020 12:40:16 GMT

Hi All,

im trying to create a std deviation calculation to show how far away from the price a certain customer is.

so i have this logic:

=min({<Customer>} total <Customer> Aggr({<Customer>}If(PricePaid = FirstSortedValue({<Customer>} TOTAL <Customer> PricePaid, -Aggr(Sum({<Customer>}[Quantity]), Customer, PricePaid)), only({<Customer>}PricePaid)), Customer, PricePaid))

which finds by each customer the most frequent price each customer has paid for a particular product, as shown below an example:

what i want to do is then create ST deviation for these results that are created in using the logic above.

is this something that i can incorporate into a Stdev expression?

Re: STD Deviation from an AGGR function.

Brett_Bleess — Thu, 02 Jan 2020 16:15:19 GMT

Maybe the following would work:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/New_Statistics_Box.htm

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Statistics_Box.htm

Best I have, hopefully that may be of some help, if not, hopefully someone else that is better at development will be able to suggest something. You could try the Design Blog area too, but I did some searching, was not finding much related to stats though...

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett

Re: STD Deviation from an AGGR function.

lorenzoconforti — Thu, 02 Jan 2020 20:45:35 GMT

You just need to wrap your function in another aggregation and then calculate the standard deviation; please note you had some unnecessary set expressions in your formula which I've removed

=Stdev(aggr(min(total <Customer> Aggr(If(PricePaid = FirstSortedValue( TOTAL <Customer> PricePaid, -Aggr(Sum([Quantity]), Customer, PricePaid)), only(PricePaid)), Customer, PricePaid)), Customer))