Intro to Qlik Sense Mashups

By Bernard de Bruin

Hi all, I’m Bernard, and in this post I will introduce myself to you and tell you more about the Qlik Sense API and Mashups. I would especially like to tell you why and when you’d use mashups instead of the ‘normal’ Qlik Sense dashboards.

First, a short introduction about myself, I’m Bernard de Bruin and I’ve been at Bitmetric since October 2017. Before starting as BI Consultant I studied Interactive Design, followed by a Digital Media and Communications study at the HU University of Applied Sciences. Here, I came into contact with the world of Business Intelligence when I did my minor in Big Data and Analytics. Seeing the interesting applications and potential, I decided to further pursue combining the disciplines of data, web development and interaction.

In my first blog at QlikFix, I want to show and tell your a little bit more about mashups and why you might want to use them. I will also show you an example of a simple mashup.


Mashups

Now that I introduced myself lets take a look at mashups with Qlik Sense. We will look at what a mashup is, what it can be used for and when and why you may choose to create a mashup.


What is a mashup?

I mentioned the word mashup quite a few times now, but what does it really mean? The Cambridge Dictionary describes it as:

a website or application that uses information or technology from different websites.

As you can see mashup means that you use technologies from different websites, and this is exactly what you can do with the Qlik Sense APIs. Using different web development languages you can extract data (Engine API)  from Qlik through the APIs and display it in your website. To make things simpler, you can even embed complete objects from your Qlik Sense (Capabilities API) applications.


When might you consider using a Qlik Sense Mashup?

So now you may be wondering “Cool that I can combine Qlik’s engine or capabilities with web technologies, but what is the use of it?”.

What you may have noticed about Qlik Sense, especially when you come from a QlikView background, is that there are limitations when it comes to designing a layout. Some things might be fixed by using an extension or a widget, but that’s for another blog post. Here we will look at the other solution, using a mashup.

You can extract data from Qlik using the API’s. This data can be stored into Javascript and can be used to create cool views, dynamic text or create a visualization. To create visualizations you need to have knowledge about libraries like D3, ECharts or another visualization library. If you are only just starting with mashups, I’d recommend using the capabilities API to get already created visualizations from Qlik Sense itself. 


Example mashup: the history of Formula 1.

In this example, I created a mashup based on Formula 1 data, both historical as well as the latest races. Technologically, I’ve combined data and visualization from Qlik within a web page using HTML/CSS and Javascript.

The screenshot above shows an impression of the mashup. The mashup is automatically updated the day after a race.

In this mashup I chose to use a story telling approach that uses data and visualizations from the underlying Qlik application. Specifically, the bold text is fetched from the Qlik API and placed into the HTML page using Javascript. Track, driver and team information is translated from Qlik data into the correct images. Besides the story view, I’ve also embedded a few Qlik Sense sheets for further data exploration.

You can explore the full mashup here. Keep in mind that this is only a first version. I will be attending the API track at the Masters Summit for Qlik, where I hope to expand my skills and views. See you there?

About The Author

Bernard de Bruin

Bernard is a BI Consultant at Bitmetric. He comes from a background of Interactive Design, Digital Media and Communications, but quickly learned that he likes data. Bernard loves to combine the disciplines of data, web development and interaction. In his spare time you can find Bernard in the gym, playing video games or trying to kill himself on his motorbike.

2 Comments

  • 1
    Masi
    September 23, 2019 - 16:13 | Permalink

    HI Bernard, can you tell us something about the Qlik Sense licences you need to keep such a mashup running. thx in advance

  • 2
    September 24, 2019 - 18:26 | Permalink

    Hi Masi,

    To keep a mashup running we have the following options:
    To use the Capability API for yourself you need Qlik Sense Desktop, to use it in your organisation you need Qlik Sense Enterprise (you will need a license for every user), or you can use the Qlik Analytical Platform (for anonymous entrance).
    If you only want to use the Engine API you can also use Qlik Core.

  • Leave a Reply

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

    Read previous post:
    Tutorial Tuesday: Implementing version control for Qlik Sense with Git, GitHub and Visual Studio Code

    Welcome to my second Blog post, which will be a basic tutorial of how to setup a lightweight version control...

    Close