2 Replies Latest reply: Jun 16, 2016 11:44 AM by Alec Whitaker RSS

    Using Qlikview with imported data to change bar graph

    Alec Whitaker

      Hello,

       

      I am trying to use Qlikview to display data imported from SQL as a bar graph. I want to make it so that if the bar graph value is below 2, the bar will turn red in color. Also, if the bar value is above 15, it will be black in color. Anything in between I would like to be green.

       

      In C# code, something along the lines of this:

       

      If (QuantityOnHand < 2)

      {

      Turn color red

      }

      Else If (QuantityOnHand > 15)

      {

      Turn color black

      }

      Else

      {

      Turn color green

      }

       

      Can somebody please direct me on the best way to accomplish this in Qlikview?

       

      I would greatly appreciate any help.