topic Re: Changing background colour in listbox in QlikView

Changing background colour in listbox

Thu, 09 May 2013 13:23:05 GMT

Hi - i want to change background colour of a listbox (the way you put a "background" colour for a dimension using the "+" before it in "used dimensions") based on the values of a firls that is not in the listbox. Can i do that?

Re: Changing background colour in listbox

Thu, 09 May 2013 13:43:17 GMT

I've bookmarked because I would like to know if this is possible too. I've wanted to have my listboxes act as a RAG for a while now

Re: Changing background colour in listbox

Thu, 09 May 2013 13:49:58 GMT

I also added an expression "only({1} CORP_TITLE_SIMPLIFIED)" to my listbox with DImension "Name", and it should ideally show the Title associated with that person. It works for some people but shows "-" for others, does anyone know why?

Re: Changing background colour in listbox

flipside — Thu, 09 May 2013 14:05:21 GMT

The trick is to use a straight table chart with a hidden expression. You can then format the background as you wish.

flipside

Re: Changing background colour in listbox

Thu, 09 May 2013 14:05:28 GMT

Hi,

to change the background color of a listbox go to Properties - Presentation tab - Background button - check Color and select color you want. In addition you must change Selection Style Override (Properties - Presentation tab) not to be QlikView Classic.

Best regards

Yani

Re: Changing background colour in listbox

Thu, 09 May 2013 14:54:48 GMT

That doesn't let one do conditional formatting on background colours

Re: Changing background colour in listbox

Wed, 22 May 2013 13:23:31 GMT

The Only function only returns a value if there is a single value to return. In your case, it probably works for some because there is a single value and returns "-" for others because there are multiple options.

Alternatively, I would try Min/Max or MinString/MaxString. This will always return a result and might solve your problem, although I can't say for sure without knowing more.

Re: Changing background colour in listbox

Wed, 22 May 2013 13:40:56 GMT

Try this Select listbox properties->presentation->background->color->calculated

write your expression in the calculated color field and check the color of list box hope it helps

Re: Changing background colour in listbox

Wed, 22 May 2013 13:47:40 GMT

ykrumova is correct - Presentation->Background AND change Selection Style Override.

The only issue is that conditional formatting in a list box is an aggregated conditional and changes only the entire background (i.e. not calculcated for each individual option in the list box).

For example:

Table:

LOAD * INLINE [

PERSON, FLAG

A, 1

B, 1

C, 0

D, 0

E, 1

F, 0

G, 0

H, 0

I, 1

J, 1

]

Then create a list box for PERSON. If you add the conditional statement in Background "=If( FLAG, rgb(120,220,120), rgb(255, 255, 255))". This will only change the entire list box background if every PERSON selected has 1 for FLAG. If at least one PERSON has 0 for FLAG, then it will remain white.

Re: Changing background colour in listbox

flipside — Wed, 22 May 2013 14:08:09 GMT

Hi,

PFA a sample as I described earlier using charts.

flipside