Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

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

please let me know

10 Replies
Anonymous
Not applicable
Author

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
]
;