Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Background & font Color depending on condition

Hi Community,

how can i set up a List Box or Table Box, so that rows have a different background & font color depending on a condition?

For example in case of the background i tried it with List/Table Box > Properties > Presentation > Background > Color >

Formula = If(SALE_COUNTRY='AT', Red(), White())

As a result only when i choose AT the style i changing, and then for the whole object.

1.png

But i need another behavior, so that only the matched Country is styled, all the time (When country is selected and not)

Such a behaviour is working with a Table Diagram.

2.png

How can i achieve such a behaviour also in other object types?

Labels (1)
2 Replies
senarath
Creator III
Creator III

Hi,

I doubt you could do this in a list box. List box back ground is applied as a whole. If you add a expression to a list box, expression back ground can be set conditional.

This is possible as long as you use either a Dim or expression.

thanx

Anonymous
Not applicable
Author

Hi,

expressions of List boxes can not be styled in detail (for example background).

3.png

In my initial post i mentioned already that using table box for that is also not working.

Anyone else an idea?