keep a color joined to a value

[Anonymous]

Hallo!

In a qlikview sheet I have a list of customers in various gaphics based on their revenue, importance and so on, but a single customer is not rapresented in every chart at the same rank position, so it hasn't the same color.

For example, the customer "X" is at the top position for revenue, and QV assignes him the blue color in the relative chart, but it is on the second position for importance and so QV assignes him the red color in the relative chart.

Is it possible to set that the same customer keeps the same color in every chart ?

Thanks.

N.

[vinieme12]

create an excel table with  rgb values mapped to each Customer

[vinieme12]

See Attached Sample

[rahulpawarb]

Hello Nicola,

Hope you are doing good!

I agree with Vineet! However, if you have limited set of values for customer name dimension then you can make use of PICK and MATCH functions in background color expression. Refer below sample snippet:

Pick(Match(CustomerName,'X', 'Y', 'Z'),Red(), Green(), Blue())

This will set color as Red, Green & Blue for customer 'X', 'Y' & 'Z' respectively.

Regards!

Rahul