article QlikView App: Multi Column List Box in Member Articles

QlikView App: Multi Column List Box

stevedark — Wed, 29 May 2013 22:02:09 GMT

This example shows how to create a multi column List Box, that behaves like a normal list box, but with multiple distinct columns.

The object is created not using a List Box, but rather a Chart of type Straight Table - with multiple dimensions attached to it. All values are always shown, as in a List Box, by using an expression with a 'full set' Set Analysis on it. The green, grey and white colours are provided by custom Background Colour code on the dimensions.

In the example there is a one-to-one relationship between all the fields in the 'List Box'. The solution should however work where this relationship is less ordered.

This QlikView was written as a response to the following QlikCommunity thread:

http://community.qlik.com/thread/54044?tstart=0

Steve Dark

http://www.quickintelligence.co.uk/

Re: QlikView App: Multi Column List Box

DavidFoster1 — Fri, 25 Oct 2013 11:00:53 GMT

I like this. One of my gripes with the table box that there is no way to stop it collapsing when selections are made.

the colouring falls down if you make multiple selections. I wonder if use a MATCH based approach would be better for handling the background colouring.

Re: QlikView App: Multi Column List Box

stevedark — Fri, 25 Oct 2013 14:30:51 GMT

Hi David - I added some more data in the inline load and the highlighting of the selected fields works as I would have expected. Are you wanting the green highlight to cover the entire row of fields if any one value is selected?

To do this you would need to modify the colour expressions on the three dimensions. Where the white colour is currently showing this would need to have another IF around it, so that if there was a selection in any one of the three fields then it should show green otherwise it would be white.

Steve

Re: QlikView App: Multi Column List Box

Anonymous — Fri, 04 Jul 2014 09:22:42 GMT

Good design but the problem with table boxes is you can't Ctrl+Select to pick multiple items. Event though, tables have more options for designing how it looks -