topic Re: cumulative figures on chart not as expected in QlikView

cumulative figures on chart not as expected

Thu, 23 Jan 2014 16:16:51 GMT

I'm trying to produce a line graph to display a year on year trend for the cumulative sales

the data comes in looking like the attached excel file 'imported data'

the members are summed by month and I can produce a quantity of members by month/ year

If the chart is a straight / pivot table I can also produce the cumulative totals

using

rangesum(Above(Column(1),0,RowNo()))

or similar

however when i then try and look at it in chart form even though im using the same template as the graph above it cumulates all the years on top of one another. I can seperate the year out by selecting the years from a list box but ideally being able to see them all together would be more beneficial.

Is there a simple way of doing this.

Sorry but cant send actual data or script , hopefully the description above is adequete

Re: cumulative figures on chart not as expected

Thu, 23 Jan 2014 16:49:44 GMT

Hi Lee

Not sure to understand what you want but if the goal is to show a graph like above (year and month dimensions) with cumulated values it exists a property where you just check "cumulate" in expression tab

best regards

Chris

Re: cumulative figures on chart not as expected

Gysbert_Wassenaar — Thu, 23 Jan 2014 16:54:28 GMT

Try setting the accumulation option for your expression, --sum(Members)?--, to Full Accumulation.

Re: cumulative figures on chart not as expected

Fri, 24 Jan 2014 15:32:07 GMT

slaps head , oh of course.. many thanks