Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
sspawar88
Creator II
Creator II

Ordering of Colors In Stack bar chart?

Hi Community,

here i'm using the stack bar chart.

Problem is when works on local machine it gives certain order of colors in first chart but when upload on server its gives another ordering of color.

Colors1.PNGColors2.PNG

i used following expression in background color

if(Count({<param_name={'TEMP'}, param_value={'<=-1>=-10'}>} param_value)

/Count({<param_name={'TEMP'}, param_value={'<=-1'}>} Total <region_name> param_value),rgb(255,0,0),

if(Count({<param_name={'TEMP'}, param_value={'<=-10.1>=-13.9'}>} param_value)

/Count({<param_name={'TEMP'}, param_value={'<=-1'}>} Total <region_name> param_value),rgb(255,255,51),

if(Count({<param_name={'TEMP'}, param_value={'<=-14>=-17.9'}>} param_value)

/Count({<param_name={'TEMP'}, param_value={'<=-1'}>} Total <region_name> param_value),RGB(255,178,102),

if(Count({<param_name={'TEMP'}, param_value={'<=-18'}>} param_value)

/Count({<param_name={'TEMP'}, param_value={'<=-1'}>} Total <region_name> param_value),RGB(102,204,0)))))

How can i set ordering of Color?

3 Replies
phaneendra_kunc
Partner - Specialist III
Partner - Specialist III

Can you check your sorting. By default it will be Auto, can you change that and see?

sspawar88
Creator II
Creator II
Author

Sorting Consist fields that i have used in Chart..

but colors Expressions are at Background Color.

Michael_Tarallo
Employee
Employee

Hi Satish, can you send me your app and I can test on my server environment?

Mike T

Qlik

Regards,
Mike Tarallo
Qlik