topic From two columns to one column?! in QlikView

From two columns to one column?!

Tue, 03 Nov 2015 13:09:03 GMT

I have a table with columns TeamHome and TeamAway and there is a table called Team which includes all values from the TeamHome and TeamAway columns. What I want to have is that on the frontend is a listbox where I can choose between several teams from TeamHome and TeamAway in one Listbox. How to build a datamodel which can do this without an syn table?

Thankss !

Re: From two columns to one column?!

swuehl — Tue, 03 Nov 2015 13:13:41 GMT

Maybe like this using CROSSTABLE LOAD:

Fact:

LOAD recno() as ID, * INLINE [

TeamHome, TeamAway, GoalHome, GoalAway

1, 2, 2, 0

];

CROSSTABLE (Location, Team)

LOAD ID, TeamHome as Home, TeamAway as Away

Resident Fact;

Team:

LOAD * INLINE [

Team, Name

1, Germany

2, Italy

];

Re: From two columns to one column?!

Gysbert_Wassenaar — Tue, 03 Nov 2015 13:14:26 GMT

Perhaps this tutorial on alternate states helps: Using Alternate States to Select Multiple Values in a List Box with Different Attributes