Standard Deviation Aggregate

Anonymous — Tue, 21 Jul 2015 19:07:02 GMT

Hello,

I am taking the standard deviation of the sum of sales for the hierarchy an item belongs to for each week for a particular store. I am selecting one item and a date range. The standard deviation is based on the sum of sales for the hierarchy (SubClass) for each week outside of my date range.

The following expression gives me the standard deviation for sub class sales outside of the time period but does not include the weeks where the item I selected did not actually sell.

Any help would be greatly appreciated.

STDEV( Total<Store> {$<[Year Week]=E([Year Week])>}

Aggr(

Sum(Total<SUB_CLASS, [Year Week], Store>{$<[Year Week]=E([Year Week]), Item=>}Sales),

SUB_CLASS, [Year Week], Store))

topic Standard Deviation Aggregate in QlikView

Standard Deviation Aggregate