3 Replies Latest reply: Dec 27, 2017 8:31 PM by Pablo Labbe RSS

    Multi Dimension Columns in QLIK SENSE Bar Charts

    vidya sagar malla

      Hi All,

       

      Hope you guys are doing fantastic. I have a simple requirement . How to Create Multi Dimension Bar chart with the sample data below.

       

         

      YearProductAmount
      2010Apple10
      2011Apple20
      2012Apple30
      2010Bat50
      2011Bat60
      2012Bat70
      2010Cake15
      2011Cake20
      2012Cake25

       

       

      Bar Chart should look like this Qlik Sense.

       

      Y- axis : Sum(Amount)

      X-axis : 1. Year

                   2. Size.

       

      "Size"  is a Dimension expression which is :

      =if(Aggr(Sum(Amount),Year,Product)>50 ,'Greater Than $50',

      if(Aggr(Sum(Amount),Year,Product)<=50 ,'Less Than $50',

      if(Aggr(Sum(Amount),Year,Product)>100,'Greater then $100' )))

       

      Color Legend: Product.

       

      Issue I am facing is : There is no option to add 3 dimensional columns in Qlik sense. Maximum I can create only 2.

       

      If we cant achieve the same bar chart what would be the alternate solution for this?.

       

      Thanks in advance.

      -Vidya