Discussion Board for collaboration related to QlikView App Development.
I have a straight table
Now here the top 10 stores are appearing using Dimension Limit
I want to use the darkest green for the top store and then the color will be gradually lighter for the lesser value.I have tried to do that using colormix().But it didn't work out.Please help me out.
Mybe you should use aggr on you dimension
=argb(sum(Sales) / max(TOTAL aggr(sum(Sales), Site_Name)) * 255,0,172,0)
View solution in original post
Its not possible to dynamically assign the darker and lighter color.
But you can use the Background color option to give a static color for a given range (Which you will have to define)
you can use argb where (a) will reflect Your value. Use this in Expression background
argb(Sum(Sales) / max(TOTAL (sum(Sales), * 255,0,172,0) )
Try background color expression like:
Note: You would have different dimension. And you might want to change the color RGB different.
try setting the colour to something like:
ARGB(55 +20*(11-Rank(Sum(Sales)) ,0,255,0)