Hi All,
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.
Region Number of Employes
United States 100
A 35
B 25
C 10
D 30
Thank you.
