Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

From two columns to one column?!

Hi

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 !

2 Replies
swuehl
MVP
MVP

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

];

Further reading:

The Crosstable Load

Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand