RGB() in list box

Mon, 12 Jan 2015 16:29:35 GMT

Hi All, suspect this may be impossible though want to give it a try anyway.

Basically I have a listbox with year values in it from 2012 to 2015. I have a theme running across my document where year data is represented by different colors based on the year. I have an inline table in place with RGB codes matching up to the year so that I can set the colors programitcally. I get that it IS possible to change the color of the font in a list box, and that this is achieved by changing the list selection style override to anything other than the default. I have set the color of the text to be dependent on the RGB code, though this is dependent on the SELECTED year value rather than the value present in the table. So if 2012 is selected, all text shows as the color assigned in the inline table to the year value 2012.

What I want, in theory, is this.

2012 2013 2014 2015

Though I am getting this until a year is selected

2012 2013 2014 2015

and when a year, 2012 in this example, is selected I get this

2012 2013 2014 2015

Happy for this to be moved, aware I'm pushing the boundaries of 'new to qlikview' with this question, though I am new to qlik.

all the best,

Dave.

Re: RGB() in list box

Clever_Anjos — Mon, 12 Jan 2015 17:47:15 GMT

I don´t know how to do this using standard listbox

You can trick it using a straight table

PFA

Re: RGB() in list box

stigchel — Mon, 12 Jan 2015 17:50:53 GMT

You can use a straight table instead of a listbox. The color setting in the listbox is not aware of the 'dimension' Year, so you will not be able to set a different color per year in a normal listbox. With a straight table you can and with some tweaking it looks and acts just like a listbox. See attached example.

topic Re: RGB() in list box in QlikView

RGB() in list box

Re: RGB() in list box

Re: RGB() in list box