topic Re: List box for a multiple option field in QlikView

List box for a multiple option field

Wed, 10 Sep 2014 04:58:43 GMT

I have a field that comes from multiple option data. The multiple options have been combined into one field with the responses separated by spaces. For example,
1 Pain FirstAid Medicine

2 FirstAid

3 Pain Medicine

4 Pain ReferGP

I would like to create a list box with the four values Pain, FirstAid, Medicine, ReferGP and then by clicking on one of the options select all records with that particular value. For example by selecting Pain, records 1,3 and 4 would be selected, by selecting Medicine records 1 and 3 would be selected.

Does anyone know how I can do this? I have played around with list boxes without much success.

Re: List box for a multiple option field

rwunderlich — Wed, 10 Sep 2014 05:17:13 GMT

It's probably easiest if you separate the treatments into distinct items using subfield():

LOAD

,subfield(Treatments, ' ') as TreatmentItem

Inline [

RecID, Treatments

1, Pain FirstAid Medicine

2, FirstAid

3, Pain Medicine

4, Pain ReferGP

]

;

Then create a listbox for TreatmentItem.

-Rob

Re: List box for a multiple option field

Wed, 10 Sep 2014 05:28:05 GMT

Hi,

Use this script

Load FieldName,SubField(FieldName,' ') as Keyword Inline [

FieldName

Pain FirstAid Medicine

FirstAid

Pain Medicine

Pain ReferGP ];

Re: List box for a multiple option field

Wed, 10 Sep 2014 06:28:00 GMT

Thanks for the prompt reply. I tried the following

Load

subfield(Outcome,' ') as OutcomeItem

RESIDENT Raw_Data;

and it created the fields okay but when the list box is created the selections do not work. The link to the original data seems to have gone. Any suggestions?

Re: List box for a multiple option field

rwunderlich — Wed, 10 Sep 2014 06:36:13 GMT

You need to include the source field (Outcome) to provide linkage.

Load

Outcome,

subfield(Outcome,' ') as OutcomeItem

RESIDENT Raw_Data;

-Rob

Re: List box for a multiple option field

Wed, 10 Sep 2014 22:44:19 GMT

Thanks Rob. That works.