topic Re: Can i create a single list box based on multiple columns? in QlikView

Can i create a single list box based on multiple columns?

Anonymous — Sat, 31 Oct 2015 20:25:29 GMT

how do I create a single list box from the column values of multiple columns

please let me know

Re: Can i create a single list box based on multiple columns?

swuehl — Sat, 31 Oct 2015 20:30:49 GMT

The more important question is:

What do you expect to happen when you make selections in this list box?

Re: Can i create a single list box based on multiple columns?

Anonymous — Sat, 31 Oct 2015 20:40:27 GMT

when I make a selection of a value from list box the selected value should be selected in the chart , it might be in muitple rows , so say for example Rome has ids 1 and 2 and the data in my chart has rows 1- 10 , I need to display both 1 and 2 rows as value Rome is in both the rows.

Re: Can i create a single list box based on multiple columns?

swuehl — Sat, 31 Oct 2015 20:59:31 GMT

Still not sure if I understand what you are trying to achieve.

If you have a table like

LOAD * INLINE [

ID, Country, City

1, Italia, Roma

2, Italia, Firenze

3, France, Paris

4, France, Nice

];

you can load the field values of Country and City into a single field 'Value' like this, linking to the original table by ID

CROSSTABLE (Field, Value)

LOAD * Resident T;

Then, creating a listbox for field Value, selection in field Value will filter the records in table T.

Re: Can i create a single list box based on multiple columns?

Anonymous — Sat, 31 Oct 2015 21:35:51 GMT

OK , Let me try to explain you one more time ,below is my sample data

I want a filter with all the students names under class1,2,3 .. so that when I filter on Vicky I would see id - with 1 and 2

Hope this makes sense !

ID	DATE	Teacher	Class 1	Class 2	Class 3
1	1/1/2015	Tom	Vicky	John	Sam
2	1/2/2015	Eric	Nickr	Vicky	Kevin
3	1/3/2015	Catalina	Kevin	Zara	Null

Re: Can i create a single list box based on multiple columns?

swuehl — Sat, 31 Oct 2015 21:54:00 GMT

Ok, I think the solution I proposed above will solve your request: Transform your table from a cross table into a straight table using a CROSSTABLE LOAD:

CROSSTABLE (Class, Student, 3)

LOAD ID,

DATE,

Teacher,

Class1,

Class2,

Classe3

FROM YourTable;

[Assuming you haven't loaded YourTable so far. If you want to keep YourTable in the data model, remove DATE and Teacher from the CROSSTABLE LOAD and set the third parameter from 3 to 1 (number of fields not to transform). ]

Then you can select 'Vicky' from a 'Student' list box.

Re: Can i create a single list box based on multiple columns?

Anonymous — Sat, 31 Oct 2015 22:07:45 GMT

Sorry , but I quite didn't get it , I don't have Class or Student columns in the sample data ? What are they refereeing to? I get 3 is referring to 3rd parameter ...

CROSSTABLE (Class, Student, 3)

Re: Can i create a single list box based on multiple columns?

swuehl — Sat, 31 Oct 2015 22:12:56 GMT

Class and Student fields will be generated by QV from your fields Class1, Class2, Class3, ...

I suggest that you run the script I posted above and have a look at

The Crosstable Load

Re: Can i create a single list box based on multiple columns?

Anonymous — Sat, 31 Oct 2015 23:28:46 GMT

Ok Thank you ... I think I am almost there .. can you please tell how I can make all this in one table .. the cross table is getting to the main table on class1 .. how to I avoid that .. can I get all the value including Student in one table ?

Re: Can i create a single list box based on multiple columns?

swuehl — Sat, 31 Oct 2015 23:37:00 GMT

Can you post your current script (the main table LOAD and the CROSSTABLE LOAD)?

Re: Can i create a single list box based on multiple columns?

Anonymous — Sun, 01 Nov 2015 04:38:29 GMT

Here it is

SCHOOL:

LOAD * INLINE [

ID, DATE, Subject,Teacher, Class 1, Class 2, Class 3
1, 1/1/2015,Physics, Tom, Vicky, John, Sam,
2,1/2/2015,Math, Eric, Nickr, Vicky, Kevin,
3,1/3/2015,Science, Catalina, Kevin, Zara, Null,
];

CROSSTABLE (Class, Student,1)

LOAD [Class 1],

[Class 2],

[Class 3]

RESIDENT SCHOOL;
Tution:
LOAD * INLINE [
Subject, Date
Physics, 1/2/2015
Math, 2/3/2015
Science, 3/1/2015
];