topic Re: keep a color joined to a value in QlikView

keep a color joined to a value

Anonymous — Tue, 31 Jan 2017 10:33:17 GMT

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.

Re: keep a color joined to a value

vinieme12 — Tue, 31 Jan 2017 10:41:44 GMT

create an excel table with rgb values mapped to each Customer

Re: keep a color joined to a value

vinieme12 — Tue, 31 Jan 2017 11:33:01 GMT

See Attached Sample

Re: keep a color joined to a value

rahulpawarb — Tue, 31 Jan 2017 12:42:36 GMT

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