Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Color the background of the expression according their value

Dear all,

I have a straight table

Dimension-Site_Name

Expression-Sum(Sales)

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.

1 Solution

Accepted Solutions
stabben23
Master
Master

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

5 Replies
kaushiknsolanki

Hi,

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)

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
stabben23
Master
Master

Hi,

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) )

stabben23
Master
Master

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

tresesco
MVP
MVP

Try background color expression like:

argb(255-rank(Sum(Sales))*20, 50,100,40)

Capture.PNG

Note: You would have different dimension. And you might want to change the color RGB different.

effinty2112
Master
Master

Hi Debasmita,

try setting the colour to something like:

ARGB(55 +20*(11-Rank(Sum(Sales))  ,0,255,0)

Cheers

Andrew