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: 
Anonymous
Not applicable

Calculating Stdev across quarters and ignore date selector

I'm using the “vAllDates” variable to ignore my date selector in a chart calculation. The first formula works great but calculates the standard deviation across all rows of data. I need to calculate the standard deviation across the calculated standard deviation of each quarter. The second formula make the correct calculation, but does not ignore my data selector.

 

I need the second formula to ignore the date selector like the first formula does.

 

Stdev({$<$(=vAllDates)>}MSDRG_Weight)

 

Stdev({$<$(=vAllDates)>} Aggr(Avg(MSDRG_Weight), FiscalYearQtr))

 

Appreciate your help!

 

1 Solution

Accepted Solutions
sunny_talwar

Try this

Stdev({$<$(=vAllDates)>} Aggr(Avg({$<$(=vAllDates)>} MSDRG_Weight), FiscalYearQtr))

View solution in original post

2 Replies
sunny_talwar

Try this

Stdev({$<$(=vAllDates)>} Aggr(Avg({$<$(=vAllDates)>} MSDRG_Weight), FiscalYearQtr))

Anonymous
Not applicable
Author

Perfect! Thank you so much Sunny.