Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All ,
In excel using conditional we can get color shading from light faint to deep based on values of a field .Example : Sales
Can this be achieved in Qlikview ? And how ?
Thanks
Shekar
Or may be like:
background color : RGB(255-RowNo()*10,100-RowNo()*1, 150-RowNo()*1)
You can play with different color combinations similarly. RowNo() would give you the color shading.
You may try this?
You need to graduate the background colours for the expressions. The ColorMix functions will return a graduated colour based on an expression value and limit colours. The easiest way is to use the ColorMix Wizard on the Expression editor menu which will help you create a ColorMix function step by step.
Hi Anil ,
Thanks for reply . I see that i already have same setting in color area .
I am attaching sample qvw . Can you please help me in replicating similar color shading for the pie chart in there .
Regards
Shekar
Put simply:
=ColorMix1(expr, Red(), Green())
Expr returns a value from 0 to 1. Red() is the colour at 0, Green the colour at 1
=ColorMix2(expr, Red(), Yellow(), Green)
Expr returns a value from -1 to 1. Redis for -1, Yellow for 0 and Green for 1.
Please find attached qvw
Thanks for the reply .
Please replicate same in pie chart attached
Or may be like:
background color : RGB(255-RowNo()*10,100-RowNo()*1, 150-RowNo()*1)
You can play with different color combinations similarly. RowNo() would give you the color shading.
Any better way stalwar1 , can you also suggest something on this?