3 Replies Latest reply: Mar 19, 2013 5:54 AM by Darren Hambleton RSS

    Creating a Stacked Bar Chart on two sets of expressions

      Hello all,

       

      I'm pretty new to Qlikview and have just started to play around on the bar charts.

       

      I am currently creating a combo chart that shows the basics of Revenue, Cost and the margin. currently I have 2 bars 1. Revenue, 2. Cost and the margin is a line, but what I am trying to do with no luck is show a chosen month and the year to date figure on the same chart.

       

      So I would have:

       

      1) Stacked Revenue bar Month/Year to date.

      2) Stacked Cost bar Month/Year to date.

       

      Then I have 2 different lines for the margins

       

      I have created 6 different expressions Revenue, Cost and Margin by both Month and Year, these are against a Project dimension.

       

      Currently I can only manage to either group or stack all the expressions together, I sure this is something simple which I am just missing.

       

      Kind Regards

       

       

      Darren