Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Colormix wizard may help..see this link if it can help..
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
Colormix wizard may help..see this link if it can help..
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.
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
thanks it worked perfectly. i used the Colormix wizard