Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
jlp_laurastar
New Contributor III

Cumulate values in a Line Chart

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

Tags (3)
1 Solution

Accepted Solutions
jlp_laurastar
New Contributor III

Re: Cumulate values in a Line Chart

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

View solution in original post

5 Replies
vikram_patro
New Contributor III

Re: Cumulate values in a Line Chart

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

Sokkorn
Honored Contributor

Re: Re: Cumulate values in a Line Chart

Hi Jean,

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

Untitled.png

See sample attached file.

Regards,

Sokkorn

jlp_laurastar
New Contributor III

Re: Cumulate values in a Line Chart

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

jlp_laurastar
New Contributor III

Re: Cumulate values in a Line Chart

A lot of views.

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

jlp_laurastar
New Contributor III

Re: Cumulate values in a Line Chart

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

View solution in original post