topic List Box Edits in QlikView

List Box Edits

tmumaw — Wed, 20 Oct 2010 21:07:01 GMT

I have created a list box which shows Customer name, Address, City, State and Zip. Some of the customers in the list box are prospective customers and some are already customers. Is there a way to make the prospects red in color vs the alread customers green?

thanks

thom

List Box Edits

johnw — Wed, 20 Oct 2010 21:49:48 GMT

Nope.

BUT... you can simulate a list box fairly well with a chart. I've added something like your requirement to the third "list box" in the attached file. Warning - it's difficult to make out the red or green color on the light green or light gray background after you've made a selection. It's kind of difficult even without a selection.

Edit: Oops. Not only is it difficult to make out, but it's wrong for values that aren't selected. Working on it. Probably a way to do it.

Edit: Fixed, but it looks like you already solved it for yourself. 🙂

List Box Edits

tmumaw — Wed, 20 Oct 2010 21:49:57 GMT

Figured it out. You can't change colors on a field in a listbox. So I created a chart and made the expression 1 then hid it. Thanks....

List Box Edits

tmumaw — Wed, 20 Oct 2010 21:51:26 GMT

thanks John. That is exactly what I did.....