Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Aggregate of an Aggregate function

 

Hello Experts! I could use some help-

 

I’m trying to create an aggregate function of an aggregate function. See below:

 

 

Original equation:

 

X =stdev(aggr(sum([Time Counted Completed Transactions]), Process, Employee))

 

 

How I want to augment it:

 

Y = X/sum(X)

 

 

To become this final equation:

 

= stdev(aggr(sum([Time Counted Completed Transactions]), Process, Employee)) / sum(stdev(aggr(sum([Time Counted Completed Transactions]), Process, Employee)) )

 

  Because I’m already using aggregate functions to take standard deviations of each of these summed values, I can’t perform another aggregation on top of it. Do y’all have any suggestions about how to proceed?

Thanks-

Amelia

 

5 Replies
yoganantha321
Creator II
Creator II

Amelia,

why can't try it out storing in variables.

Not applicable
Author

Sounds great! How would I accomplish this?

sunny_talwar

So you get multiple Stdev which you want to add up? Can you share a sample where you are trying to do this?

yoganantha321
Creator II
Creator II

Amelia,

just store the expression for 'x' in variable.

example let vX=stdev(aggr(sum([Time Counted Completed Transactions]), Process, Employee)) and expression as vX/sum(vX)

the above said is an example you can try with this............

Not applicable
Author

Sounds like this should work!

However, I'm not gathering information from a static source- the data that is being used to determine standard deviation is constantly being added and filtered by different categories. Will this still achieve my purpose?

Thank you so much-

Amelia