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:
and color is:
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