Some people build QlikView dashboards to review the financial outcomes of their companies. Others use it to monitor their everyday operations in plants and warehouses. There are individuals who even create applications to analyze fun stuff like the Olympic Games or TV Series. In my opinion, QlikView should be exclusively used to answer humanity’s greatest inquiries and analyze relevant topics that affect our lives and our future; important things such as Pokémon
When I was a kid, I used to play Pokémon games all the time. Blue, Yellow, Silver, Sapphire, Stadium, Snap, Pinball, Trading Card Game, you name it. And well, since everyone’s going a little crazy about Pokémon Go these days, I decided to create a QlikView document based on the original 151 Pokémon in the first generation.
The first interesting thing about this app is that all the data comes from http://pokeapi.co/ using the Qlik REST Connector. At first I thought it was going to be difficult, but it’s as simple as creating an OLE DB connection. You just type in the address and the server will respond with a JSON structure that can be easily interpreted by the connector. After that, it’s QlikView as usual.
I only added some variables and a FOR cycle so I could read several tables (one for each Pokémon) without manually modifying the connection string. For more references, go to the QVD Generator included in the materials.
By the way, if you want to add extra tables to the data model, be sure to check PokeAPI in detail. They have a lot of information that you can retrieve in the same QVD Generator and make this app even better.
I’m sure you’ve already downloaded and opened the app by now, but let me give you a quick tour around it:
Dashboard: This is the first step of our journey! The opening tab displays general information about all the Pokémon in Gen 1 like the types, chains, forms and habitats.
Pokémon: This one is one of my favorites. The second sheet gives you all the information you need about a Pokémon. From its weight and height to all of its stats or even the moves it can learn. Use the arrows to navigate or just look for your favorite Pokémon with the search button.
Stats: If you’re really trying to become the very best (like no one ever was), the Stats tab will help you recruit an appropriate team.
Scatter: You know me too well, no QlikFreak app is complete until it gets a scatterplot!
Histogram: A simple, yet powerful visualization. If you’re not familiar with these charts, why don’t you take a look at this post?
Moves: Now, now… Which Psychic moves with high power and accuracy can my Fire Pokémon learn? Wait, is that possible?