topic Re: evaluate string in table in Integration, Extension & APIs

evaluate string in table

dionverbeke — Wed, 12 Jul 2017 07:47:20 GMT

Hi,

I would like to dynamically evaluate a string I got from a table in a Qlik Extension.

The story:

1. I retrieve a hypercube

2. In the hypercubematrix one column in a row contains a formula: e.g. =left('Qlik is Great',4)

I would like to have the formula evaluated in the extension at runtime.

3. The result should be a hypercube with the column evaluated: e.g. 'Qlik'

Which api do I need to use?

kr,

Dion

Re: evaluate string in table

ErikWetterberg — Wed, 12 Jul 2017 12:19:15 GMT

Hi Dion,

This is kind of tricky... You need to call app.evaluate to get this done. But this method is not available in the App API. Instead you need to use enigma.js. Since enigma is autogenerated, all methods defined in the engine API are available. Do note that enigma is flagged as experimental, though.

In an extension you can find enigma at this.backendApi.model.enigmaModel. That is a reference to the GenericObject wrapper, and in this case you need the app wrapper at this.backendApi.model.enigmaModel.app. This means you could do:

this.backendApi.model.enigmaModel.app.evaluate("1+1").then(function(reply){console.log("got reply",reply)});

And you will get a printout like this:

got reply 2

Hope this helps

Erik Wetterberg

Re: evaluate string in table

konrad_mattheis — Wed, 12 Jul 2017 12:39:05 GMT

Hi,

you have to be carefull, the enigma is only available in newer versions of qlik sense and the path is changed.

In the newest qlik release this is move from .enigmaModel direct to .model

bye Konrad

Re: evaluate string in table

ErikWetterberg — Wed, 01 Nov 2017 12:40:43 GMT

What release are you refering to? In September 2017 it is still available at

this.backendApi.model.enigmaModel

Erik