Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Itsmeakshata
Contributor
Contributor

Standard deviation for an aggregated field

Hi All,

I am trying calculate Standard deviation for an aggregated value, which is throwing an error saying "nested aggregation" is not possible. Does anyone have any solution regarding the same.

Thanks,

Labels (1)
3 Replies
Anil_Babu_Samineni

@Itsmeakshata We appreciate if you can share the expression and screenshot to work with. 

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
vinieme12
Champion III
Champion III

you need to wrap your expression AGGR() on the chart dimensions as below

= stdev( 

AGGR(   YourExpression  ,  ChartDimension1, ChartDimension1 )

)

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Chanty4u
MVP
MVP

Try this 

Stdev( AGGR( Sum(Sales), Year ) )