Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

albertestrada
New Contributor II

Aggr Std Dev on each Row

I need the aggr std dev by Bill Num to replicate on each line item (652.13726).  Can someone help me please?

I can achieve the replication with a set analysis but the std dev is based on transaction (31.373207).

Tags (2)
1 Solution

Accepted Solutions
Highlighted

Re: Aggr Std Dev on each Row

Try this may be:

Stdev(TOTAL Aggr(Sum(Price), Bill_Num))


Capture.PNG

2 Replies
Highlighted

Re: Aggr Std Dev on each Row

Try this may be:

Stdev(TOTAL Aggr(Sum(Price), Bill_Num))


Capture.PNG

albertestrada
New Contributor II

Re: Aggr Std Dev on each Row

Thank you Sunny, that worked.