I want to apply colormix on a Qlik native bar chart.
The dataset contains one dimension region and other is number of employees in that region and its a drill down dimension.
I want to apply a colormix with the range . For example - the country has highest number of employees should be dark blue color and the lowest have light blue color. The blue color fades away in descending order with respect to number of employees in that region. Please find example below:-
Region Number of Employees
United States 100 United Kingdom 20 China 50 Germany 10 Russia 60 Australia 25 Canada 45 India 50 Japan 20
And as I mentioned its a drill down dimension and if I select united states, it drill down to the regions in United states. And it should also reflect the same colormix, Highest being dark blue and lowest is light blue.
