The Qlik DataMarket allows you to source additional data externally. This data is provided by Qlik to enrich your current reporting data set. It is a "data as a service" cloud offering, which allows you to access a collection of different valuable, up-to-date and ready-to-use datasets.
For the purpose of this recipe, we will make use of an inline data load which gives the information on sales and the base currency:
- Create a new Qlik Sense application and call it
QS_DataMarket. - Load the following data into the QlikSense data load editor:
ExampleData: LOAD * INLINE [ Base currency, Sales US dollar, 6300 ]; - Save and reload the application.
- Open the
QS_ DataMarketapplication. - Create a new sheet called
Salesand go to the Edit mode for the sheet. - From Qlik Sense Desktop, open the Data manager as shown in the following screenshot. Please note that this feature is only available from Version 2.0 onwards.
The data manager is a new feature of Qlik Sense. We will cover the different aspects in other recipes; for now, let's look at the Qlik DataMarket.
- Click on the
button located on the left-hand side of the Data manager screen. - Next, click on the
button. - For this example, we will click on the
option. - Next, select the
option. - The next screen allows you to choose what data you want to load. Select the options as shown in the following screenshot:
- Click on the
button at the bottom-right corner of the screen. - Once the load has finished, go to the application editor and drag a KPI object from the asset pane onto the main content pane.
- Create a new master item
Measurewith the nameSales($)and the following expression:Sum(Sales)
- Create a second master item
Measurewith the nameSales (in selected quote currency)and the following expression:Sum ({<[Quote currency]={$(='[' & GetFieldSelections([Quote currency]) & ']')}>}Sales * [Exchange rate]) - Drag the first and second measures onto the KPI object. The final object should look like the following image:
In this example, we enrich the existing internal data set with an external source. Here, we simply add a euro conversion rate from our dollar amounts but we could have added several other currency conversions. The limitations of how much data you can augment to your internal data set is based on the data Qlik provide in the DataMarket, and having the right fields in your internal data set to cross reference to the right DataMarket field. The ones shown in this example are free. To get access to even more data sources in the DataMarket, you have to pay a subscription fee. The price list for these subscriptions can be obtained from Qlik.
The current offerings in the Qlik DataMarket are broken down into six categories:
- Business
- Currency
- Demographics
- Society
- Weather
- Economy
These categories are shown in the following screenshot:
Being able to expand your own core data with that in the Qlik Data Market allows you to take an outside-in view of the business and its environment, helping you to explore and connect market trends to see opportunities and challenges. Qlik plans to keep adding to the DataMarket with more sources in future releases. The data sources are updated in Qlik as they are updated in the source systems. For example, exchange rate information will likely be updated daily, whereas country population data is more likely to be updated annually.