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/