Extracting min and max value on Standard Deviation

[fatihtomruk]

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]

Hi,

I'm not sure to understand;

min and max with your formula don't work ?

regards

[fatihtomruk]

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

[simenkg]

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

[fatihtomruk]

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

[simenkg]

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]

Can you attach the sample data and expected result?

[fatihtomruk]

Example is attached.