topic Re: Engine API: CreateChild not visible in app in Integration, Extension & APIs

Engine API: CreateChild not visible in app

Anonymous — Wed, 02 Nov 2016 07:41:32 GMT

All,

I am trying to use the Engine API to add a new bar chart to a certain sheet using the CreateChild method. According to the return message, the new object is successfully created and is enlisted in the object list of the sheet when calling ChildInfos on the sheet. The problem is however that the object is not showing up in the actual Qlik Sense app.

So my question is: how can I make the new bar chart, which is a part of the sheet, appear in the Qlik Sense app? Is there any visibility setting I should set? And how can I specify where it should be shown on the sheet and with which physical dimensions?

Inside an extension or in a website integration, this is all rather straightforward as you can include the object directly in the html definitions.

Thanks in advance,

Gregory

Re: Engine API: CreateChild not visible in app

Alexander_Thor — Wed, 02 Nov 2016 16:54:34 GMT

On the sheet object there is a full dynamic property called "cells" which is an array of the different sheet objects.
Example:

{

"name": "KxdNL",

"type": "gauge",

"col": 1,

"row": 0,

"colspan": 6,

"rowspan": 4

}

You would have to perform some collision detection with the objects already placed on the sheet so they do not occupy the same grid cell.

Re: Engine API: CreateChild not visible in app

Anonymous — Fri, 04 Nov 2016 07:36:34 GMT

Alexander,

Thanks once again. I managed to change the cells property and the charts are showing up on the correct position.

Kind regards

Gregory

Re: Engine API: CreateChild not visible in app

mborsadw — Sat, 14 Oct 2017 03:47:40 GMT

How did you change the Cells property on the Sheet object using engine api?

Re: Engine API: CreateChild not visible in app

JFico_Bardess — Fri, 19 Apr 2019 14:41:59 GMT

You can use applyPatches:

{
	"handle": 3,
	"method": "ApplyPatches",
	"params": {
		"qPatches": [
			{
				"qOp": "add",
				"qPath": "/cells",
				"qValue": "[{ \"name\": \"MUJjf\", \"type\": \"barchart\", \"col\": 1, \"row\": 0, \"colspan\": 22, \"rowspan\": 3}]"
			}
		],
		"qSoftPatch": false
	},
	"outKey": -1,
	"id": 14
}

Re: Engine API: CreateChild not visible in app

nitinsaivishnu1 — Wed, 08 May 2019 12:09:27 GMT

can you share a sample of the json with which you created the bar chart thats can be visible on the sheet ?

and also can you tell me how to change the dimensions of the same bar chart using applyPatches method?

Re: Engine API: CreateChild not visible in app

JFico_Bardess — Wed, 08 May 2019 14:31:19 GMT

The bar chart was created on the sheet with something like this:

var apiMsg = { "handle": handle, "id" : id, "method": "CreateChild", "params": { "qProp": barchartProperties } };

where barchartProperties was queried from the session object using

var apiMsg = { "handle": handle, "id": id, "method": "GetEffectiveProperties", "params": {} };

I don't know how to change the qlik dimensions of the chart, if you mean physical dimensions then that's controlled by rowspan/colspan in the first call.