topic Use external data "on the air" with API? in Management & Governance

Use external data "on the air" with API?

nicolas_martin — Fri, 16 Mar 2018 17:17:31 GMT

Hello,

Let's suppose I have a Qlik document in which there is (at least) 2 dimensions:

- Year

- Office

I also have an API that takes 2 parameters (year and office) as input and provide data as output (a table with 2 columns: "customer" and "sum of sales" as values).

I would like to do the following:

In my Qlik application, I make a selection on Year / Office.
In my Qlik application I have a bar-chart object that is connected to my API with the selected values for "year" and "office".

Eg. :

='http://myAPIserver/getSalesPerCustomer?year=' & concat(DISTINCT Year, ',') & '&office=' & concat(DISTINCT Office, ',')

This chart display as result a bar-chart with "customer" as dimension and "sum of sales" as value.

And I want to use the Qlik charts, not a custom D3js chart in an iframe or something.

A QlikSense reseller told me it was possible to do such thing in QlikSense thanks to "the API feature of Qlik Sense".

After a lot of searches, it looks like the "Advanced Analytics Integration" but it seems very very VERY complicated.

Did I missed a documentation that explains step by step how to do this?

Thank you for your help.

Re: Use external data "on the air" with API?

Digvijay_Singh — Sun, 18 Mar 2018 14:59:00 GMT

Not sure if you have seen this one -

Introduction to integrate Qlik Sense in your Software/Site (embedded analytics)

Re: Use external data "on the air" with API?

nicolas_martin — Mon, 19 Mar 2018 13:14:00 GMT

Thank you for the link.

I don't see the part where it shows how I can display external data not loaded in the application.

Re: Use external data "on the air" with API?

Anonymous — Wed, 21 Mar 2018 11:17:59 GMT

Possible to this in the load script, but I do not think one can do this in the front end without a bespoke extension.

Re: Use external data "on the air" with API?

nicolas_martin — Thu, 22 Mar 2018 14:01:31 GMT

I made a workaround with VB macro and DynamicUpdateCommand function, but it only works with the desktop client, not the ajax version (because of the use of COM components to either create an ODBC connection or a HTTP request.