Qlik Community

Ask a Question

Documents

QlikView documentation and resources.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY

QlikView App: Multi Column List Box

stevedark
Luminary Alumni
Luminary Alumni

QlikView App: Multi Column List Box

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/

Labels (1)
Attachments
Comments
DavidFoster
Specialist
Specialist

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.

0 Likes
stevedark
Luminary Alumni
Luminary Alumni

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

0 Likes
lixcablix
Contributor II
Contributor II

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 -

0 Likes
Version history
Revision #:
1 of 1
Last update:
‎2013-05-29 06:02 PM
Updated by: