Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
gaurav_S
Partner - Contributor II
Partner - Contributor II

Want to create World Cup Schedule

I have 4 groups in every group I have 4 teams I want to create one schedule by using loops and flags in Qlik sense how I create these schedules, If anyone has a solution please let me know.

Labels (2)
2 Replies
jochem_zw
Partner Ambassador
Partner Ambassador

Please show us the data otherwise we can't help you

gaurav_S
Partner - Contributor II
Partner - Contributor II
Author

I am adding the data manually as below.

Teams:
Load * Inline [
Team_ID,Team_Name
1,India
2,England
3,Pakistan
4,Netherland
5,Australia
6,South Africa
7,Afganistan
8,Kenya
9,Scotland
10,Srilanka
11,Zimbabwe
12,HongKong
13,West Indies
14,Nepal
15,New Zealand
16,UAE
];

Venues:
Load * Inline [
VenueID, VenueName
1, Rajiv Gandhi International Stadium Hydrabad
2, Wankhede Stadium Mumbai
3, Arun Jaitley Stadium Delhi
4, M.A. Chidambaram Stadium, Chennai
5, M. Chinnaswamy Stadium Bengaluru
6, Himachal Pradesh Cricket Association Stadium Dharamshala
7, Maharashtra Cricket Association Stadium Pune
8, Atal Bihari Vajpayee Ekana Cricket Stadium Lucknow
9, Eden Gardens Kolkata
];

I want to create a schedule in which every team will play 4 matches that start on any particular date for every 1 match like the 1st Jan 1st match 2nd Jan 2nd match.

I tried by using loops but I didn't get the proper solution.