Set Background color for only one value

Thu, 18 Apr 2013 09:40:10 GMT

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

Mon, 17 Jun 2013 16:05:18 GMT

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:)

topic Set Background color for only one value in QlikView

Set Background color for only one value

Re: Set Background color for only one value