topic Color background based on top 3 sales in QlikView

Color background based on top 3 sales

renjithpl — Thu, 26 Jul 2012 10:03:23 GMT

Hi All,

I want a code which will highlight my top 3 sales in a pivot table with red color. ?

Regards

Renjith

swuehl — Thu, 26 Jul 2012 10:05:57 GMT

Use a background color attribute expression (open attributes by clicking the + next to the expression name in expression tab):

=if(rank(sum(Sales))<=3,lightred())

renjithpl — Thu, 26 Jul 2012 11:31:36 GMT

its showing red for all the entries...

swuehl — Thu, 26 Jul 2012 11:37:50 GMT

Ok, you probably use more than 1 dimension and want the top 3 sales across all values? Try adding a TOTAL qualifier:

=if(rank(TOTAL sum(Sales))<=3,lightred())

Thu, 26 Jul 2012 12:30:42 GMT

For background color in expression, use the following expression

If(Rank(Sum(Sales])<= 3),RGB (255,0,0))