topic Re: Listbox Hack in QlikView

Listbox Hack

Wed, 05 Aug 2015 17:38:01 GMT

What is the best possible way to create a listbox when data/cell can have multiple values?

Sample Data

AA, BB

CC,DD,AA,BB

DD,BB

How to create a List Box with following selection for the user:

if the user selects AA, then following items should be highligted from the table AA - AA, BB - CC, DD, AA, BB

if the user selects BB, then following items should be highlighted from the table AA,BB - CC, DD, AA, BB, DD, BB

If the user selects AA and DD, then following items should be highlighted from the table AA - AA, BB - CC, DD, AA, BB, - DD,BB

Thanks!

Re: Listbox Hack

maxgro — Wed, 05 Aug 2015 22:11:09 GMT

maybe this?

SampleData:

load * inline [

field

AA, BB

CC,DD,AA,BB

DD,BB

] (delimiter is ';') ;

Link:

load

field,

trim(subfield(field, ',')) as field2

Resident SampleData;

Re: Listbox Hack

Thu, 06 Aug 2015 13:53:36 GMT

Perfect, thanks!

Re: Listbox Hack

Fri, 21 Aug 2015 02:55:50 GMT

Couple of Follow up....

1. How do you clean up list which is represented in following format?

22, 33, 4 4

33,22, 11

4 4,33

22,11,4 4

/* how do we remove unwanted spaces. Also the Data has space '4 4 ' which is possible so REPLACE funtion won't be appropriate */

2. We created two pie charts using 2 columns derived from subfield() but when we select data from one pie chart the other pie chart doesn't show accurate vaules.? Can you please invesitgate?

Re: Listbox Hack

maxgro — Fri, 21 Aug 2015 14:57:31 GMT

1) to remove the space at the begin and at the end of every value you can trim the subfield (table Tmp) and then rebuild SampleData (concat with the id)

SampleData:

load rowno() as id, * inline [

field

22, 33, 4 4

33,22, 11

4 4,33

22,11,4 4

] (delimiter is ';') ;

Tmp:

load id, trim(SubField(field, ',')) as field1, rowno() as id2

Resident SampleData;

DROP Table SampleData;

SampleData:

load id, Concat(field1, ',', id2) as field

Resident Tmp

Group By id;

DROP Field id;

Link:

load

field,

trim(subfield(field, ',')) as field2

Resident SampleData;

2) I don't understand, better if you open a new discussion with an example (.qvw) of the problem

Re: Listbox Hack

Fri, 21 Aug 2015 19:53:42 GMT

Thanks Again!

Refer List, SubField and textCount