topic Multiple values in a list box... in QlikView

Multiple values in a list box...

Anonymous — Tue, 24 Mar 2015 19:37:51 GMT

The below is my straight table I have 45 columns that I would like to show in a list box and be able to select best approach to solve? For example,I would select Car in a list box and only ID 2 values would show.

ID	Car	Van	SUV	Truck	Bus	SmartCar	Header 8	Header 9
1		x	x	x	x	x	x
2	x
3								x
4
5				x

List Box:

Car

Van

Suv

Truck

Bus

etc...

Re: Multiple values in a list box...

JonnyPoole — Tue, 24 Mar 2015 20:27:51 GMT

You could load a new table in the data model using a series of resident loads off the main table. The new table will associate all the vehicle types to the IDs where they have an 'X'.

Types:

Load

ID,

'Car' as Type

resident <TableWithIDs>

where Car='x';

concatenate (Types)

Load

ID,

'Van' as Type

resident <TableWithIDs>

where Van='x';

concatenate (Types)

Load

ID,

'SUV' as Type

resident <TableWithIDs>

where SUV='x';

etc...

Then add 'Type' as a list box. When you select Car it will filter the main data set for only the IDs belonging to that Type.

Re: Multiple values in a list box...

Anonymous — Tue, 24 Mar 2015 20:41:54 GMT

Use crosstable load - see attached

Re: Multiple values in a list box...

ToniKautto — Wed, 25 Mar 2015 04:28:50 GMT

I think you need to eliminate the blank (empty string values) from the cross table.

Adding SET NullInterpret =''; to the script should do the trick.