5 Replies Latest reply: Aug 28, 2013 8:46 AM by Aldea Cosmin RSS

    Stack bar using a dimension

    Steve Zagzebski

      I have the following data and want to create a stack bar chart:

       

      What I want is for the X-axis to be the month, the expressions (2013 Sales Per Member and 2012 Sales Per Member) to the be the bars side by side for each month. Then I want the other dimension (line of Business) to be stacked for each expression. Can't see what I am doing different from a few of the examples I looked at on this site - but I can't figure how to stack them.

       

      Incurred MonthLine of Business2013 Sales Per Member2012 Sales Per Member
      296.76316.61
      AprElectronics2.192.51
      JanElectronics2.762.53
      MarElectronics2.943.45
      FebElectronics3.453.15
      FebFurniture9.9212.13
      MarFurniture10.0912.65
      AprFurniture10.5912.41
      JanFurniture12.7712.31
      FebKitchen57.4863.01
      MarKitchen59.0167.60
      AprKitchen60.8858.68
      JanKitchen64.6966.18
        • Re: Stack bar using a dimension
          Oleg Troyansky

          You are trying to make a chart that is both grouped and stacked - the two expressions side by side require a grouped chart, while the Line of Business require a stacked chart. This is not something you can implement in QlikView.

           

          Even if it was possible, the visual effect would be really hard to process - you'd need to follow monthly trend, through comparing year by year and divided by Line of Business... Too complex...

           

          You'll need to reduce the complexity by one dimension - either show a stacked chart of monthly trends by Line of Business, or show a grouped chart of Monthly Trends comparing Year over Year, but without the distribution by Line of Business.

           

          best,

           

          Oleg Troyansky