Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
=>green, red, yellow, amber
Can you post a qlikview document that demonstrates the problem?