Qlik Sense Mash-Up API Tutorials

[Brian_Munz]

Hi everyone,

I've created a series of tutorials around the basic functions of the Qlik Mash-up APIs.  Hopefully the tutorials will be able to get people up and running in creating web sites and applications using this API.

There will be some blog posts on Branch coming soon with more details and tutorials, but I wanted to make these available now.

The posts reference some code samples on Qlik Branch here:

http://branch.qlik.com/projects/showthread.php?308-Sample-Code-for-Mash-up-API-basics

The videos can be found here:

Part 1: Getting Set Up - https://www.youtube.com/watch?v=ffyZy7RlSoE

Part 2: Embedding Objects - https://www.youtube.com/watch?v=OzzsynxIUMM

Part 3: Connecting to Fields - https://www.youtube.com/watch?v=fqGwrGhlW-I

Part 4: Creating HyperCubes - https://www.youtube.com/watch?v=pDbDbkc22Ds

Thanks, hopefully they'll be helpful for learning how to use this API.

[Brian_Munz]

Yeah, between that version and the latest it changed from workbencheditor to workbench.

[#3]

Hi Brian

I've got a quick question. Is it possible to use 1 dimension and 2 measurements in a hypercube?

Right now I can catch the data of 1 dimension in an array and the data of 1 measurement in an array.

So I can display a chart with 1 measurement. I'm actually looking for a way to display a chart of charts.js with multiple measurements. Maybe there are other ways to do this?

Robbe

[Alexander_Thor]

Hey Robbe,

Sure you would just add another measure definition to your measures array.

Stubbed out a definition below that is pretty barebones.

"qMeasures": [
   "qLibraryId": "",
   "qSortBy": {
     "qSortByNumeric": 1
     }
   },
   "qDef": {
     "qLabel": "Measure 1",
     "qGrouping": "N",
     "qDef": "=Sum(Field1)"
   },
   "qLibraryId": "",
   "qSortBy": {
     "qSortByNumeric": 1
     }
   },
   "qDef": {
     "qLabel": "Measure 2",
     "qGrouping": "N",
     "qDef": "=Sum(Field2)"
   }
}]

As you know have added a new column to the data that is returned to you make sure the InitialDataFetch now has a width property that equals the amount of columns in the hypercube, in this case 3.

[#5]

Hello Brian,

In the very first tutorial you say workbench is not as complicated and intensive as using the Engine API but it can do most of what you'd want to do in a web application.

Could you please explain what are the limitations of using the workbench. Specifically I'm thinking of making a small "web application" that would communicate through a RESTful api (both GET and POST) with our server.

/Regards.

PS: here's what I'm thinking we could try to do. Instead of using Qlik sense default workflow/GUI to load new CSV files we'd rather get a list of files from the server, load some, and depending on the user's interactions (selections) with Qlik Sense other CSV files are loaded-in and so on. Having our own app serving those files (CSV or some other format) allows us to alter those files/streams on the fly to accommodate the user's intent.

[Anonymous]

Inspiring post Brian, many thanks for taking time to share.

[#7]

Hi

I tried to do the mashup steps

and I get the foloying error when I tried to view mashup, what to do? its in sense enterprise

[ErikWetterberg]

The most likely reason for this is that the app id is not correct, when you deploy to server you need to update your mashup with sthe server app id (a GUID).

Erik

Please mark the appropriate replies as correct or helpful so our team and other members know that your question has been answered to your satisfaction.

[#9]

Hi, TY,

the error messsage display when I clik view/edit the new template, I didnt pass to define app ID

!

[#10]

more screen shoots

[#11]

I open a new mashup and its ok now