topic Background & font Color depending on condition in QlikView

Background & font Color depending on condition

Anonymous — Thu, 21 Aug 2014 09:54:30 GMT

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.

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.

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

Re: Background & font Color depending on condition

senarath — Thu, 21 Aug 2014 10:03:01 GMT

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

Re: Background & font Color depending on condition

Anonymous — Thu, 21 Aug 2014 10:17:49 GMT

Hi,

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

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

Anyone else an idea?