Discussion board where members can get started with QlikView.
I am trying to do SPC Chart and I stuck with Average. I have counted repairs per week and I am trying to calculate total average of repairs per week.
Aa a dimmension I have Week Number
Expression 1 = Count(RepairsID)
Expression 2 =Avg(Aggr(Count(RepairsID), WeekNumberSUNSAT)), the same effect when I type =count(RepairID)/ count( distinct WeekNumberSUNSAT)
Results in table below ( I extracted only 20 weeks for one of the year).
In total for 4 years I have 8155 repairs, so average should be 39.2067 repairs per week, which obviously I didn't get with my expression.
In script under RepairID i have below statement:
AutoNumber(Repair&Date&Case_No) as RepairID
I tried to replicate calculations from:
Could you please advise?
Thanks for your help,
I found solution, Expression should be as below:
=Avg(TOTAL Aggr(Count(RepairsID), WeekNumberSUNSAT))
View solution in original post
Do you have a sample app?