topic Re: Aggregate of an Aggregate function in QlikView

Aggregate of an Aggregate function

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Aggregate of an Aggregate function

yoganantha321 — Mon, 03 Apr 2017 14:33:08 GMT

Amelia,

why can't try it out storing in variables.

Re: Aggregate of an Aggregate function

Mon, 03 Apr 2017 14:36:44 GMT

Sounds great! How would I accomplish this?

Re: Aggregate of an Aggregate function

sunny_talwar — Mon, 03 Apr 2017 14:46:31 GMT

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

Re: Aggregate of an Aggregate function

yoganantha321 — Mon, 03 Apr 2017 15:42:41 GMT

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

Re: Aggregate of an Aggregate function

Mon, 03 Apr 2017 15:50:17 GMT

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