- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Leauge match Display
Hi,
I have excel sheet with two tabs.
Team sheet have all team which are participating.
League sheet have league matches with opponent.
Now I want to display league sheet by selecting list box
for example
if I select WAKFIELD or PETERBORUGH from List box it supposed to show me data from League sheet.
Regards
Vinay
- Tags:
- new_to_qlikview
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
League:
LOAD RecNo() as GameID,
Team1,
Goal as Goal1,
Team2,
Goal1 as Goal2
FROM Team.xlsx (ooxml, embedded labels, table is League);
Teams:
Load GameID,
Team1 as Team
Resident League;
Load GameID,
Team2 as Team
Resident League;
It is in fact very similar to a Canonical Date, although it concerns teams and not dates.
HIC
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
League:
LOAD RecNo() as GameID,
Team1,
Goal as Goal1,
Team2,
Goal1 as Goal2
FROM Team.xlsx (ooxml, embedded labels, table is League);
Teams:
Load GameID,
Team1 as Team
Resident League;
Load GameID,
Team2 as Team
Resident League;
It is in fact very similar to a Canonical Date, although it concerns teams and not dates.
HIC
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be like this...
TEAM:
LOAD Teams as Team1
FROM
Team.xlsx
(ooxml, embedded labels, table is Team);
TABLE1:
LOAD Team1,
Goal,
Team2,
Goal1
FROM
Team.xlsx
(ooxml, embedded labels, table is League);
Concatenate
LOAD Team1 as Team2,
Goal as Goal1,
Team2 as Team1,
Goal1 as Goal
FROM
Team.xlsx
(ooxml, embedded labels, table is League);
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks Henric & Manish. Its work. I appreciated your help.
Thanks
Vinay