topic Re: Can I reproduce List Box Functionality with Text Boxes? in QlikView

Can I reproduce List Box Functionality with Text Boxes?

Wed, 01 Apr 2015 19:05:10 GMT

Please see the screen shot below. I have a List Box in the middle showing Revenue Categories. The bar chart at left will display Revenues for as many of the categories as I select from the list. I have unchecked the "Expressions as Legend" option inside the chart, because it is redundant to have the categories listed twice.

What I am attempting to do on the right is create a custom Revenue Categories list that will replace the default List Box and also double as a Legend. Each color square is an individual Text Object, and each of the labels next to the square is as well. I've opened the Properties of each of these objects and set the Action to point to the right Revenue Category.

THE PROBLEM IS, I can only select/display one Revenue Category at a time. What I want is to be able to select and compare multiple categories (as is shown in the screen shot). Is there any way to make the Text Object stay on so I can select more than one at a time?

Alternately, is there any way to assign individual colors to the Windows Check Boxes in a List Box?

Thanks for your feedback!

Russell

Re: Can I reproduce List Box Functionality with Text Boxes?

rwunderlich — Wed, 01 Apr 2015 19:33:54 GMT

Change your action to ToggleSelect. That will allow you to have more than one selection.

See this blog post for ideas on using color in a listbox.

http://qlikviewcookbook.com/2014/12/listbox-color-chips/

-Rob

http://masterssummit.com

http://robwunderlich.com

Re: Can I reproduce List Box Functionality with Text Boxes?

Anonymous — Wed, 01 Apr 2015 19:42:08 GMT

See attached - not exactly as you ask, but rather close. No need for actions, it is a real list box. Background is transparent, and color text boxes are on the bottom layer.

Re: Can I reproduce List Box Functionality with Text Boxes?

Wed, 01 Apr 2015 20:09:42 GMT

This looks promising. How do I manipulate the cell colors?

Re: Can I reproduce List Box Functionality with Text Boxes?

Wed, 01 Apr 2015 20:11:59 GMT

Rob,

The ToggleSelect option works perfectly. I'll also take a look at the listbox blog post.

Thanks!!!

Russell

Re: Can I reproduce List Box Functionality with Text Boxes?

Anonymous — Wed, 01 Apr 2015 20:14:12 GMT

There are no cell colors - these are text boxes of different colors. List box is transparent (see Presentation tab, button "Background"). Just move it aside and see.

Re: Can I reproduce List Box Functionality with Text Boxes?

Wed, 01 Apr 2015 20:17:22 GMT

I found the bottom layer. Looks good until I go to Web View, then the alignment gets off.

Re: Can I reproduce List Box Functionality with Text Boxes?

Anonymous — Wed, 01 Apr 2015 20:20:46 GMT

Yes, I remember this issue. Had to choose the list box font carefully, usually it is the culprit.