Discussion Board for collaboration related to Creating Analytics for QlikView.
I woule like to create an chart that is showing the moving average of completness (in %) of my task, and i don't find the expression needed to use a moving average.
For exemple of moving average in my source file, i have:
In this way, i would like to have a line chart showing the moving average evolution by date.
I don't know if it's clear, but it will be really nice if someone can help me on this tricky chart
See the attached app,
Thank you for your helpfull example, i think i understand the formula.
How would you implement this in a chart where the Dimension chosen is the date, and my current expression is:
"Count(Distinct if(Action_Date >= Action_Date_Close,ID_Planning)) / Count(DISTINCT ID_Planning)"
ID_planning is an unique code for every task.
Thank you so much in advance, i'm pretty new on Qlikview, and it's a bit tricky at the start
Could you post your qvw (or part of it, or even an application with false date ..) ?
It would be then easier to help you.
Here is the Qlikview with an example of the graphic where i want to change the expression, in a moving average expression.
I cannot upload files right now but you can maybe create a second expression with this formula :
Rangesum(Top([% of Recurrent tasks Completed], 1, RowNo()))/ rowno()
Then you unchek line and symbol for your first expression and check it for the new one.
The only problem with this formula is that lines removed by your if statement are counted in the moving average.
I'll try to find a better solution.
Thank you a lot for your time !