4 Replies Latest reply: Aug 8, 2011 11:57 AM by Srini r RSS

    Chart Accumulation (with Dimensions)



      I am trying to create a chart that has bars for monthly sales (the chart has the primary dimension Month and the secondary dimension Year). Also, I want the same chart to show the accumulated sales as a line (but true to the dimensions, that is, QlikView should not accumulate for all years, but create accumulated sales per month for each year).


      I have tried to setup an example of what I want, and how I have tried to solve the problem... Could anyone take a look at the attached file and help me figure out what is going on, and how I best solve the problem? I really don't understand why my set analysis is not working...






      Excel Example



      PS: I updated this discussion with an Excel file of what the chart should look like...