Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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!