topic Re: Colors based on Value in QlikView

Colors based on Value

Wed, 19 Aug 2015 06:34:24 GMT

Hi All,

I have the following data in My table. Can we display Sales background color like

10-40 red

50-70 Green

80-100 Blue

Year Sales

2005 10

2006 20

2007 30

2008 40

2009 50

2010 60

2011 70

2012 80

2013 90

2014 100

Regards

Sharath

sunny_talwar — Wed, 19 Aug 2015 06:37:02 GMT

I think you should be able to do this for Text Color Expression:

If(YourSalesExpression <= 40, Red(), If(YourSalesExpression <=70, Green(), Blue()))

Anonymous — Wed, 19 Aug 2015 06:41:40 GMT

you may be succesful using tab visual clue where you can define your Background as well as your textcolor

jonathandienst — Wed, 19 Aug 2015 06:43:49 GMT

You can play with the Properties | Visual Cues, or set a foreground colour expression (Text Color) in Properties | Expressions:

=If([Sales] >= 10 And [Sales] <= 40, Red(),

If([Sales] >40 And [Sales] <= 70, Green(),

If({Sales] > 70 And [Sales] <= 100, Blue())))

alibd225 — Wed, 19 Aug 2015 06:45:46 GMT

=if(sum(Sales)<41,Red(),if(sum(Sales)<71 and sum(Sales)>40,Green(),Blue()))

alibd225 — Wed, 19 Aug 2015 06:47:09 GMT

this is text color not background color..

expand your expression by clicking + sign. then write condition in Text Color not background color

Wed, 19 Aug 2015 06:51:33 GMT

Thanks for all

alibd225 — Wed, 19 Aug 2015 06:59:11 GMT

if you already got your ans then click correct answer and close your discussion