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:
QS_DataMarket
.ExampleData: LOAD * INLINE [ Base currency, Sales US dollar, 6300 ];
QS_ DataMarket
application.Sales
and go to the Edit mode for the sheet.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.
Measure
with the name Sales($)
and the following expression:Sum(Sales)
Measure
with the name Sales (in selected quote currency)
and the following expression:Sum ({<[Quote currency]={$(='[' & GetFieldSelections([Quote currency]) & ']')}>}Sales * [Exchange rate])
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:
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.