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

    Chart Accumulation (with Dimensions)

    Simon Haugbølle

      Hi

       

      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...

       

      Thanks

       

      Simon

       

      Excel Example

      Untitled.jpg

       

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