Color in Bar Chart

[#1]

Dear all,

I'm new in Qlik view. I'm facing problem to change color in bar chart. For your better understanding please see below screenshot. In my below chart A1-3, A4-4, A8-10, A11-15, A16-21, A30+ bar will be Green color and L1-3, L4-7 bar will be RED color. How can i solve this problem. please help me..

Regards,

Masba

[SergeyMak]

I would say let's move your calculated dimension into load script and then use it as dimension.

Or you can replace the Dimension word

if(right(Dimension,1)='A',,RGB(0, 255, 0),If(right(Dimension,1)='L',RGB(255, 0, 0)))"

with your calculated dimension