Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

sspawar88
Contributor

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
Valued Contributor III

Re: Ordering of Colors In Stack bar chart?

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

sspawar88
Contributor

Re: Ordering of Colors In Stack bar chart?

Sorting Consist fields that i have used in Chart..

but colors Expressions are at Background Color.

Employee
Employee

Re: Ordering of Colors In Stack bar chart?

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

Mike T

Qlik

Regards,
Mike Tarallo
Qlik
Community Browser