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:

Twitter Network Viz Qlik Sense Hashtag

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:

Example Twitter Data

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!