Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
fatihtomruk
New 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))

asdsasdas.PNG

Tags (1)
7 Replies
Highlighted
ogautier62
Valued Contributor II

Re: Extracting min and max value on Standard Deviation

Hi,

I'm not sure to understand;

min and max with your formula don't work ?

regards

fatihtomruk
New Contributor III

Re: Extracting min and max value on Standard Deviation

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

Highlighted
Partner
Partner

Re: Extracting min and max value on Standard Deviation

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

Highlighted
fatihtomruk
New Contributor III

Re: Extracting min and max value on Standard Deviation

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

Highlighted
Partner
Partner

Re: Extracting min and max value on Standard Deviation

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

Highlighted
qlikviewwizard
Honored Contributor II

Re: Extracting min and max value on Standard Deviation

Can you attach the sample data and expected result?

Highlighted
fatihtomruk
New Contributor III

Re: Extracting min and max value on Standard Deviation

Example is attached.