Shading the colors in Bar Chart

[rash_611]

Hi Team,

i have a productivity of engineers and i am showing that in bar chart on month wise. i need to highlight the highest value from dark green to light green. Only one Dimension and one Metrics.

Dimension - Month-Year

Metrics - Value of Productivity

i need to show the fading of colors comparing to each month.

Regards,

Grace

[avinashelite]

have you tried with the Set reference option in Qlikview.

Right click on the chart and click on Set reference, this should serve your requirement

[Digvijay_Singh · Accepted solution]

Colormix wizard may help..see this link if it can help..

Re: coloured bar chart based on value

[krishna20]

Hi,

Try like this,

goto expression tab-> select your expression-> + Expand it-> Select Background Color-> if(NumericCount (ID)>4,LightGreen(),Red()).

Set the expression condition value as per you required.

Hope it helps.

[SreeniJD]

If I understand you correctly, data will be in same color (with difference in intensity), however you should select the maximum of that KPI based on the color..

Pls correct me

Sreeni

[rash_611]

thanks it worked perfectly. i used the Colormix wizard