topic Re: Re: Cumulate values in a Line Chart in QlikView

Cumulate values in a Line Chart

Anonymous — Wed, 11 Sep 2013 07:29:01 GMT

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

Re: Cumulate values in a Line Chart

vikram_patro — Wed, 11 Sep 2013 07:36:09 GMT

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

Re: Re: Cumulate values in a Line Chart

Sokkorn — Thu, 12 Sep 2013 01:29:46 GMT

Hi Jean,

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

See sample attached file.

Regards,

Sokkorn

Re: Cumulate values in a Line Chart

Anonymous — Thu, 12 Sep 2013 06:43:20 GMT

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

Re: Cumulate values in a Line Chart

Anonymous — Fri, 13 Sep 2013 14:19:17 GMT

A lot of views.

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

Re: Cumulate values in a Line Chart

Anonymous — Wed, 25 Sep 2013 05:56:44 GMT

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