Qlik Community

Qlik Sense Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

nicolas_martin
Contributor II

Use external data "on the air" with API?

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.

4 Replies
Digvijay_Singh
Honored Contributor III

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

nicolas_martin
Contributor II

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

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?

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

nicolas_martin
Contributor II

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

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.

Community Browser