Defined list to defined color

[Anonymous]

Hi All,

I have a Excel with 2 sheet,

1. onewith a list of 20 car model name and it's sale, location of manufacturer.
2. Car model name with rbg

When loaded and creating graph, we need specific model name to have the rbg in the bar graph or pi chart.

Trying to use a variable to pick the list since if the Excel is modified with rbg will provide the changes.

PL help

stalwar1‌

Tony

[mikaelsc]

why use a variable? use field with rgb as expression in your chart per car model

[mikaelsc]

*as color expression

[sunny_talwar · Accepted solution]

See if this approach suits your need

Maintaining Color of the Dimensions in QlikView – Learn QlikView