topic Re: Configure list box to use a field where data source contains multiple selections in QlikView

Configure list box to use a field where data source contains multiple selections

dukane24 — Tue, 12 Nov 2013 15:13:37 GMT

I'll start by saying that I am new to Qlikview. It's quite possible there is a simple solution to my problem that I am not seeing.

My problem is that some of the columns in my data source can have multiple selections. For example, in the "Department" column, the database user can choose "Dept A" which is fine, or they can choose multiple departments. The database handles this by separating the selections with a semicolon, so they show as, "Dept A; Dept C, Dept D", etc. I believe my challenge is two fold: I need to set up the List Box for this field so that it only shows single department names instead of all of the multiple selections that people have chosen. Also I need to set it up so that when "Dept B" is chosen in the list box, it shows all of the single selections with "Dept B", but also instances where the field CONTAINS "Dept B", which will cover instances where multiple departments were chosen.

I appreciate any suggestions you may have.

Thanks!

Re: Configure list box to use a field where data source contains multiple selections

Anonymous — Tue, 12 Nov 2013 18:37:09 GMT

If I got the question right, the attached is the answer.

Re: Configure list box to use a field where data source contains multiple selections

dukane24 — Tue, 12 Nov 2013 19:54:49 GMT

Thank you Michael! This is exactly what I was looking for. I thought I'd have to do some acrobats with a list box expression to limit the possible field selections but this addition to the script solves both problems at once.

Re: Configure list box to use a field where data source contains multiple selections

Anonymous — Tue, 12 Nov 2013 20:30:37 GMT

A little follow up:

In the example, I joined the additional table to the original one. In real life it may be better not to join, keep as a separate table, because it creates additional rows. You don't want this if there are many columns in the table.

Regards,

Michael

Re: Configure list box to use a field where data source contains multiple selections

dukane24 — Tue, 12 Nov 2013 22:18:56 GMT

Thanks Michael. After I made this change I realized that it was adding rows but tried loading it as a separate table instead as you suggested and it worked.

Thanks again!