Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for
Search instead for
Did you mean:
Contributor III

Extracting min and max value on Standard Deviation

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))

7 Replies
Specialist II

Hi,

I'm not sure to understand;

min and max with your formula don't work ?

regards

Contributor III
Author

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

Specialist

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

Contributor III
Author

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

Specialist

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(....,)),))

Master II

Can you attach the sample data and expected result?

Contributor III
Author

Example is attached.

Community Browser