Qlik Community

Qlik Sense Data Connectivity

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

damianparodi
New 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

Re: Soccer Database trouble

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
Community Browser