Skip to main content

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
damianparodi
Contributor
Contributor

Soccer Database trouble

I have a soccer database that contains the fields :

MatchNumber- Date - HomeTeam - HomeGoals - VisitorTeam - VisitorGoals

The teams that appear in HomeTeam  and VisitorTeam are the same because some teams may play as home and sometimes plays as visitor.

Need to put in a list box with the two fields (HomeTeam and VisitorTeam) so that when I select the team "A" show me data from home and Visitor.

1 Reply
Gysbert_Wassenaar

Load your data like this:

Matches:

LOAD MatchNumber, Date, HomeTeam as Team, HomeGoals as Goals, 'Home' as HomeVisitor

FROM ...

Concatenate(Matches)

LOAD MatchNumber, Date, VisitorTeam as Team, VisitorGoals as Goals, 'Visitor' as HomeVisitor

FROM ...


talk is cheap, supply exceeds demand