topic How can you add color to List Box items with expression ? in QlikView

How can you add color to List Box items with expression ?

Wed, 19 Nov 2014 12:45:24 GMT

Hello,

I have a List Box, that draws fields/data from a SQL database. I would like each lines background color to reflect a certain condition.

Example :

if (field > 200 and field <= 100,rgb(255,47,47),

if (field > 100 and field <= 50,rgb(144,23,56),

if (field > 50 and field < 0,rgb(23,147,101),

rgb(5,5,5))))

How can I make this work and where must I place this ? I placed this in expressions and in presentation(color -> calculated) but the colors don't show up. If I add it in the expression, then I do get a colom that prints out the correct rgb(?,?,?).

Re: How can you add color to List Box items with expression ?

Wed, 19 Nov 2014 12:55:54 GMT

I dont think it is possible by line by line color in the list box,but you can add background color to the list box,find the attached application

Re: How can you add color to List Box items with expression ?

anbu1984 — Wed, 19 Nov 2014 12:58:02 GMT

Check this link

Change the text color in list box

Re: How can you add color to List Box items with expression ?

Wed, 19 Nov 2014 13:03:57 GMT

anbu cheliyan that is for the text color. I want to change the individual background of each line to show either red, green, amber, yellow. The text background color itself, not the text font color.

It's suppose to be a dashboard with these data displayed and the severity should be indicated by each items background color.

Re: How can you add color to List Box items with expression ?

Wed, 19 Nov 2014 13:05:58 GMT

Bhawna Gupta Would you say I could achieve this by using a Table Box , instead of a List Box ?

Re: How can you add color to List Box items with expression ?

anbu1984 — Wed, 19 Nov 2014 13:12:08 GMT

Check this link

how to change background colour of a list box

Re: How can you add color to List Box items with expression ?

Wed, 19 Nov 2014 13:19:37 GMT

Thanks Anbu, that's the idea !

However, when I click on an item, THEN it shows the colors in background, but not when all items are shown in the List Box ... only a matter of seconds now ! Thanks for the help

Re: How can you add color to List Box items with expression ?

Wed, 19 Nov 2014 13:38:22 GMT

Ok I managed to do the following : Created a Straight Table Chart, added the code into background expression under the designated main expression. thanks for all the help !