Discussion Board for collaboration related to QlikView App Development.
I have a problem with cumulative values in a line chart
I have a table with item, month, production qty and incident qty and i need to calculate the evolution of the production quality.
I have find the solution with rangesum(above)) functions for a simple table chart.
But when i cannot display the same information in a line chart.
You can see the result in the attached file.
First file corrupt, upload a second time
Modified by: Jean-Luc Pache
Reload the file
Go to Solution.
Solution found in this answer given by swuehl the 15.aug.2013.
Usage of aggr function + "Last, to make this work, you need Date dimension values load order to be sorted chronological (because aggr() function sorts its dimension values only by load order)."
Thanks to swuehl for his help
View solution in original post
Unable to open the attached app, can you check and upload again
Did you try to use build in accumulate function yet? See screenshot below
See sample attached file.
This solution work for the sum of one field but not for the calculation of the percentage
A lot of views.
But no answer for helping me for the cumulative percentage in my line chart.