topic Re: Extracting min and max value on Standard Deviation in QlikView

Extracting min and max value on Standard Deviation

fatihtomruk — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have Avarage and St.Dev in this table. But I want to extract the min and max values when calculating Standard Deviation. Please help..??

I have added new straigt table and written this formula,

Avg: =avg(aggr((SUM([Fiili Maliyet Tutarı])/sum(([Fiili Miktar])*-1)),BASKANLIK,Kayıt_Donemi_Text))

StDev: =Stdev(aggr((SUM([Fiili Maliyet Tutarı])/sum(([Fiili Miktar])*-1)),BASKANLIK,Kayıt_Donemi_Text))

ogautier62 — Tue, 03 Jul 2018 07:13:47 GMT

Hi,

I'm not sure to understand;

min and max with your formula don't work ?

regards

fatihtomruk — Tue, 03 Jul 2018 07:16:40 GMT

min and max values is calculating but I want to extract these when calculating the Standard Deviation.

simenkg — Tue, 03 Jul 2018 07:52:57 GMT

Under the "expression"-tab of your chart, put "total mode" to "max of rows".

fatihtomruk — Tue, 03 Jul 2018 08:29:46 GMT

Thank you Mr Simen but I couldn't try this,because it is deactive.

simenkg — Tue, 03 Jul 2018 08:35:14 GMT

It is only possible in a Straight Table.

I think if you want it in your pivot table you need to do a nested Aggr.

so max(aggr(stdev(aggr(....,)),))

qlikviewwizard — Tue, 03 Jul 2018 09:12:48 GMT

Can you attach the sample data and expected result?

fatihtomruk — Tue, 03 Jul 2018 12:18:18 GMT

Example is attached.