1 Reply Latest reply: Jun 1, 2016 6:38 AM by Chandrasheker Gompa RSS

    Color bar chart by expression

    Joan Cardona

      I'm trying to replicate a bar chart in Qlik Sense that we previously made in Qlikview. The thing is that many of the options available in Qlikview do not exist in Sense.

       

      So, this is the original chart:

      Captura_1.PNG

       

      And this is what I'm getting in Sense:

       

      Captura_2.PNG

       

      (I know the numbers aren't quite the same, this is because of new data that has been loaded in Sense but not in Qlikview).

       

      What I'd like to know is a way to make the inferior bars in each case gray, like we did in qlikview.

       

      In qlikview we used one dimension (X), and two expressions: (Y, with colors) and (Z, without colors). To obtain thiswe added an IF statement in the background color of that expression.

       

      If anyone knows some way to accomplish this we'd be very grateful.

       

      Many thanks,

       

      Joan

        • Re: Color bar chart by expression
          Chandrasheker Gompa

          Hi Joan,

           

          I have used the below expression for my below chart may be this helps..

           

          if(ValueList ('Actual', 'Plan', 'Prev Year')= 'Actual',rgb(60,2,95),

          if(ValueList ('Actual', 'Plan', 'Prev Year')= 'Plan',rgb(150,150,150),rgb(102,0,133)))

           

          You can use your dimensions and the conditions similar to above in the colours and legends and choose

           

          colours custom and choose by expression