Before I continue my ‘next post’ on Web Dashboards, I want this post to go first. This post will cover a topic I’ve been working on involving Twitter data and the relationships in that data. Many of you probably know this type of visualization already, the network visualization. As in an earlier post on doing relationships in Qlikview, this one is done in Qlik Sense using Michael Laenen’s extension for this. So before you go on reading or downloading the app at the bottom of this post, make sure you download it and unzip it to your local extensions folder if you are using Qlik Sense Desktop.
An example of what you will see in the app:
The app uses data from twitter that I collect for the hashtag #QlikSense. Here’s an example of the data format that gets loaded into Qlik Sense:
If you’d like to use this data for any other purpose, you can find a published csv-file here. You could download it locally or point to it as a webfile data source in your Qlik Apps.
What is the example about?
The example app holds the transformations and setup that are necessary to use the visualization as described on Qlik Branch. Hopefully this will help you to get an insight of how other data, like for example “Market Basket Analysis”, could be transformed to fit the visualization’s format and setup.
The visualization’s properties
In the example visualization you are looking at:
- Twitter users: they are represented by a bubble/dot
- The number of tweets: which are shown by the size of the bubble/dot
- The relationships (or mentions/interactions in this case): which are shown by the lines drawn between the bubbles/dots
- Of Twitter Users have Qlik in their username or bio description: shown by the color. Blue represents ‘Qlik’ Twitter Users, Yellow is for users not having the word ‘Qlik’ on their profiles.
For the colors I’m not really sure yet if they are persistent. And I wasn’t able to use ‘color by expression’ just yet. Hopefully our qlik branch enthusiasts will find this feedback 😉
The app
So last thing to share is the app. And because this is a social share, I once again hope you people will help spreading the word and work by paying me with a tweet ;). Oh yeah, and don’t forget; you need the extension for this visualization. Otherwise you aren’t going to experience a whole lot.
Note: The app is functional from a data source perspective. Reloading the app will get you the fresh data for you to analyze!
Dear Patrick,
How did you collect those data from Twitter. Did u use Qlik REST Connector or by any other tools?
Regards,
Arockiya
I used a tool that works with google sheets. It is called twitter archiver.
Good stuff Patrick! Would like to iterate on this with you to make it dynamic, perhaps using the new Qlik Connectors (QVsource) and Qlik Sense 3.0. You’ll see that I made a few tweaks: https://twitter.com/JWarbington/status/751974962676637696
Thanks for your input Joe! Much appreciated!
Branch links doesn’t work
I fixed it now. Branch had a redesign, also taking down the url structures that were in place. Thanks for the alert.