A couple of months ago I discovered a neat Chrome Plugin for Qlik Sense. It allow me to drag and drop table data from my browser into a Qlik Sense application.  I haven’t used it a lot, but it is quite handy when you run upon a small dataset on internet that you want to capture into Sense. It is also quite sweet to use when demoing Qlik Sense.

Fetching the final premier league table into Sense.

premierleague.wikipediaI found the final Premier League standings on the 2014-15 Premier League page on wikipedia. I want to pull this data into a Qlik Sense application.

premierleague.wikipedia.senseit

If you’ve installed the SenseIt extension you’ll notice a Qlik green barcart icon in top of your browser. When visiting the webpage holding data, click the SenseIt icon and you’ll a pop-up window where you should drag and drop your table.

premierleague.wikipedia.senseit.import

The table will be preview in the extension window where you will be able to do configuration of the import by specifying column headers, decimal separator, thousand separator and whether you should transpose the table in question or not.

  • Click the “Create App” button.
  • Click the “Open App” button.

Viola! Your Qlik Sense application is created and loaded with your data and you are ready to start designing your application.

premierleague.wikipedia.senseit.result

SenseIt is created for the Chrome browser, but I managed to install it on Opera as well without any problems using the Download Chrome Extension for Opera. SenseIt is also available as an open source project on Qlik Branch.

 

Leave a Reply

Your email address will not be published. Required fields are marked *