topic Re: Measure creation via javascript in Integration, Extension & APIs

Measure creation via javascript

eleni_theodorid — Sun, 27 Mar 2016 11:52:33 GMT

Hello,

The case that I'm trying, is to create a measure on the fly and then get the value and add it to my html.

I'm trying to create a measure via javascript, using qsocks.

I used Engine api explorer to create the json message.

{

"handle": 1,

"method": "CreateMeasure",

"params": {

"qProp": {

"qInfo": {

"qId": "SumQuantityId",

"qType": "Measure"

"qMeasure": {

"qLabel": "SumQuantity",

"qDef": "=sum(Quantity)",

"qGrouping": 0,

"qExpressions": [

"qActiveExpression": 0

"qMetaDef": {}

}

"id": 6,

"jsonrpc": "2.0"

}

This seems to work fine using the explorer.

When i use qsocks, I get "error: {"code":9,"parameter":"Missing Type","message":"Empty parameters"}".

.....

qapp.createMeasure(obj).then(function(reply) {

console.log("reply: " + JSON.stringify(reply));

}, function(error) {

console.log("error: " + JSON.stringify(error));

});

.....

Of course, I'm connected to my app, and the "obj" is the json message provided above.

Can someone help me?

Thanks in advance,

Eleni

Re: Measure creation via javascript

Øystein_Kolsrud — Tue, 29 Mar 2016 09:41:29 GMT

If you just want to evaluate the expression, then you might want to look into this engine API method: Evaluate method ‒ Qlik Sense

I'm not sure if that method is available in through the API you are using though.

Re: Measure creation via javascript

ErikWetterberg — Tue, 29 Mar 2016 10:17:05 GMT

If you don't really want to create a measure, but only get the expression evaluated, you could use the Capability APIs and the createGenericObject method. For your expression that would be something like this:

app.createGenericObject( { 
     sumQuantity: { qValueExpression: "=sum(Quantity)" } 
}, function ( reply ) {
//handle the reply
//the value will be in reply.sumQuantity
//and this function will be called whenever the value changes
});

Erik

Re: Measure creation via javascript

eleni_theodorid — Sat, 02 Apr 2016 17:09:47 GMT

Thanks a lot both of you for your quick replies.

app.evaluate("=sum(Quantity)").then(function ( reply ) {
     // do something
}, function(error) {
     // do something
});

This works fine, but it sums all "quantity", instead of selected.