Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. 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