Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

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

1 Solution

Accepted Solutions
Not applicable

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

View solution in original post

1 Reply
Not applicable

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

View solution in original post