Cumulate values in a Line Chart

[Anonymous]

Hello,

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

[vikram_patro]

Unable to open the attached app, can you check and upload again

[Sokkorn]

Hi Jean,

Did you try to use build in accumulate function yet? See screenshot below

See sample attached file.

Regards,

Sokkorn

[Anonymous]

This solution work for the sum of one field but not for the calculation of the percentage

[Anonymous]

A lot of views.

But no answer for helping me for the cumulative percentage in my line chart.

[Anonymous · Accepted solution]

Solution found in this answer given by swuehl the 15.aug.2013.

http://community.qlik.com/message/379030#379030

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