List with conditional background colors

Sun, 25 Sep 2016 07:25:11 GMT

Hello,

I want to create an object, not sure if a listbox or a straight table, or something else would be better? But I want this list to have specific background colors based on the names of the items in the list. When I select one of the items, I want the background colors of the other items to remain intact. I'm imagining something like this:

List of foods

Apples (bg color red)

Strawberries (bg color red)

Bananas (bg color yellow)

Grapes (bg color purple)

Lettuce (bg color green)

Cucumbers (bg color green)

‌

Is this possible to do? Please help! Thanks!

Re: List with conditional background colors

adamdavi3s — Tue, 27 Sep 2016 08:14:19 GMT

This is the formula you could use in the background of a table chart... just trying to figure out how best to display it so it doesn't disappear when you select items:

=pick(match(food,'Apples','Bananas','Cucumbers','Grapes','Lettuce','Strawberries'),red(),yellow(),green(),rgb(221,160,221),green(),red())

Please remember to mark this as helpful or the correct answer if I have helped you or answered your question.

topic List with conditional background colors in QlikView

List with conditional background colors

Re: List with conditional background colors