Discussion Board for collaboration on QlikView Layout & Visualizations.
I am trying to build a Xmr Chart with the data below. There is an Month/Year filter and I always calculate the Average and the Moving Range Average with the selected data only*.
But I am having a hard time to calculate de Moving Range Average, I always get an erron on the expression.
The Average I used the expression: sum(total(Sales))/GetSelectedCount(Year/Month)
For the Moving Range: fabs(sum(Sales)-below(sum(Sales)))
And for the Moving Range Avg I tried unsucessfully to use: sum(total(fabs(sum(Sales)-below(sum(Sales)))/GetSelectedCount(Year/Month)
Can anyone help me please?
Thank you very much.
Go to Solution.
Could you try
Avg(total aggr(fabs(sum(Sales)- below(sum(Sales))),Year/Month))
^ This will avg across thel range with values (count = 3)
^ This one will avg across the full range (count = 4)
Thank you very much for you help. I used the first expression and it worked great.