topic List Box Settings in QlikView

List Box Settings

Anonymous — Thu, 12 Jun 2014 20:33:34 GMT

How do you change the color of the font of the field that is contained in a list box?

I have a list box that contains a field for the year a loan was created and I can change the title but cannot change the content inside.

Is it possible?

Re: List Box Settings

Thu, 12 Jun 2014 20:43:22 GMT

You can only change the color of the font in a list box if you go to the presentation tab of your list box and change the Selection Style Override from <User Default> to anything other than Qlikview Classic. Then you can go to the font tab and change the color of the font.

Re: List Box Settings

Anonymous — Thu, 12 Jun 2014 20:45:18 GMT

Not in a list box. Maybe use a straight table with a hidden dummy expression. Color can be controlled here. It can be made look like a list box, but functions differently...

Re: List Box Settings

Anonymous — Thu, 12 Jun 2014 20:53:17 GMT

Oh, I forgot about this one - thanks Christian

Re: List Box Settings

Anonymous — Fri, 13 Jun 2014 13:18:26 GMT

Is there any way to do something similar to this for a pivot table? I cant seem to find a way to change the font color of the dimensions. I can change the expressions font color though.

Re: List Box Settings

Anonymous — Fri, 13 Jun 2014 13:27:13 GMT

Expressions have "attribute expressions", just click on the "+"-sign to the left of the expression. There is text color, background color, and other attributes there.

Re: List Box Settings

Anonymous — Fri, 13 Jun 2014 14:03:52 GMT

Thank you this helped! One last question, I have everything changed to the color I want except the title of the dimension column. Any ideas how to change that?

Re: List Box Settings

Anonymous — Fri, 13 Jun 2014 14:15:34 GMT

It is possible too, using "custom format cell".

First, go to the View menu, and turn on Design Grid. Next, right click on the cell (dimension name), and in the pop-up menu click Custom Format Cell. You'll figure out the rest. But I'm not sure if you can apply this to one dimension only, maybe it applies to all dimensions.