Create a Dynamic Color in Bar Chart

Thu, 28 Jan 2016 18:32:55 GMT

Hi Experts

I’ve a challenge to do after tomorow:

I’ve a chart which shows the Top Customers of my Company.

To customize the Top I’m using a slicer to allow user to select the top that he want.

I was challenged to create a dynamic color in the Bar Chart that shows the best customers (first half) would have to be with green tone colors (but can't be a static color, it to start in first customer with a lighter green and finish with a darker green). And the worst customers with a dynamic color orange.

The problem is that I don't want the same RGB Green for all the best customers and not the same RGB Orange for the worst. I want a pattern that begin on a lighter color and go to the same dark. I Started to use some RGBs with the Rank Function but I've habe a problem with that because I am making this assignment static.

Imagine the example:

The user select 4 Customers in slicer (which shows the 4 customers with major profit):

1ºCustomer - Light Green

2ºCustomer - Dark Green

3ºCustomer - Light Orange

4ºCustomer - Dark Orange

But if customer select 8 Customers:

1ºCustomer - Light Green

2ºCustomer - Less Light Green

3ºCustomer - More Less Light Green

4ºCustomer - More Dark Green

5ºCustomer - Light Orange

6ºCustomer - Less Light Orange

7ºCustomer - More Less Light Orange

8ºCustomer - Dark Orange

Is there possible?

Thanks!

Re: Create a Dynamic Color in Bar Chart

Oleg_Troyansky — Thu, 28 Jan 2016 18:38:43 GMT

I'd suggest exploring the Colormix Wizard - available from the File menu in the Expression Editor.

Cheers,

Oleg Troyansky

Upgrade your Qlik skills at the Masters Summit for Qlik - coming soon to Milan, Italy!

topic Re: Create a Dynamic Color in Bar Chart in QlikView

Create a Dynamic Color in Bar Chart

Re: Create a Dynamic Color in Bar Chart