1 Reply Latest reply: Jun 17, 2013 12:05 PM by sarah_mader RSS

    Set Background color for only one value

      Hallo,

       

       

      just one question.

      I have a Point-Chart and i want to set only the color of one point per excel(3 columns with R,G,B values).

      The other point should get colors from qlikview.

       

      I tried to set the Backgroundcolor of my Expression to:

       

      =$(color)

       

      and color is:

       

      =if(not isNull(R),RGB(R,G,B))

       

      Usually if i define a color for every point this works. When i give just one value RGB values I thought the "not isNull(R)" condition would prevent the other points to get this color. But instead of printing the one black and others not, all points are black.

       

      Short example, my english is not the best^^

       

      This works:                                                            This not:

       

      Car      |     R     |     G     |     B                                   Car      |     R     |     G     |     B

      Audi    |     120   |   200   |     90                                   BMW  |     56     |   70     |     90

      BMW  |     56     |   70     |     90

      Ford    |     220   |   200   |     290                               The Values Ford and Audi still

                                                                                      exist, but have no RGB-Values

       

      Thx,

       

       

      Sarah

        • Re: Set Background color for only one value

          Ok i solved the problem by myself.  In Excel tables only insert values you wanted to make spezific colors.

           

          Like:

           

          Car      |     R     |     G     |     B

          BMW  |     56     |   70     |     90

           

          And instead of inserting:

           

          =$(color)

           

          in the backgroundcolour tag of your expression,use:

           

          =if(Car='BMW',$(color))

           

          Maybe s.o. may use this too:)