Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
cclayford
Partner - Creator
Partner - Creator

Cricinfo Statsguru meets Qlik Sense

Hi all

I managed to pull live Test Match data from the Cricinfo website using the web-file connector in Qlik Sense.

I have compiled an analysis on the following disciplines:

  • Team
  • Batting
  • Bowling
  • Fielding
  • All-Rounders

If you would like access to the app on my Qlik Sense Cloud account, please send me your email address. Please note that i only have 3 invites left, so first come first serve. Your feedback will be greatly appreciated!

Notes:

The main challenge i encountered with the data, was the fact that each web page only gave me 50 rows of results. I then had to use "For Loops" in my back-end scripting to fetch the results on the other pages. Here is an example of what the web page looks like on the site:

cricinfo web page.PNG

Once i pulled the the data for all the teams and players, i proceeded to do some analysis in Qlik Sense. Here are some screenshots of the types of analysis i did:

1.PNG

2.PNG

3.PNG

4.PNG

5.PNG

6.PNG

Regards,

Christopher.

4 Replies
mdmukramali
Specialist III
Specialist III

can you please

alimukram26@gmail.com

cclayford
Partner - Creator
Partner - Creator
Author

Invite sent

Ellis
Contributor
Contributor

Hi, 

Could I please have an invite if there are any remaining?

Thank you,

Jamie

rohit18492
Contributor III
Contributor III

Hi,

Can you please help me with the Script? I am doing some analysis from Statsguru but since 50 records per page unable to do.

Kindly help.

 

Thanks in Advance