topic Re: Mashup to retrieve values from a single row straight table in Integration, Extension & APIs

Mashup to retrieve values from a single row straight table

jerryhelms2017 — Thu, 01 Nov 2018 18:57:21 GMT

I am writing a mashup that needs to retrieve two values from a single row straight table, as illustrated below. In one variable I would want the value 22333 and in the second variable 33222.

What is the JS to accomplish this?

Re: Mashup to retrieve values from a single row straight table

petter — Thu, 01 Nov 2018 19:43:34 GMT

You can calculate the two values directly with two variables without using Javascript at all.

You'll have to make use of the Aggr function which can help you grouping over the necessary dimensions and the first parameter will be the expression with an aggregation function that you want to calculate:

vVariableA=Aggr( Sum( {<Year={2017},Country={'Tinystan'}>} Something ) , Year , Country )

Re: Mashup to retrieve values from a single row straight table

jerryhelms2017 — Fri, 02 Nov 2018 13:32:02 GMT

I am looking for a mashup solution to retrieve the data points. The straight table will incorporate any needed aggregations. The standard mashup solution to retrieve the visualization object is similar to the Js code shown below. Rather than retrieving the object, I want to retrieve the values in the straight table.

var app = qlik.openApp('50fa200c-9d3b-4048-ac1e-573af8cdd11f', config);

//get objects -- inserted here --

app.getObject('QV04','xwjwJm');

app.getObject('QV03','XYThZn');

app.getObject('QV02','vpFgFAg');

app.getObject('QV01','phfXmU');

Re: Mashup to retrieve values from a single row straight table

ErikWetterberg — Sat, 03 Nov 2018 09:55:04 GMT

Hi,

You could use the createCube method in the API. I assume there are som formulas behind the values in your example, just provide them as measures and you will get a small hypercube back with the actual values.

Erik Wetterberg

https://extendingqlik.upper88.com/

Re: Mashup to retrieve values from a single row straight table

jerryhelms2017 — Thu, 08 Nov 2018 15:05:22 GMT

The following code retrieves the object model.

var app = qlik.openApp('e968b99c-595f-4106-8e78-9498b96ddd6e', config);

//get objects -- inserted here --

app.getObject('QV01','RMgxzbF').then(model => {

console.log('a: ',model.layout.qHyperCube.qSize);

model.getHyperCubeData('/qHyperCubeDef', [{

qTop: 0,

qLeft: 0,

qwidth: 2,

qHeight: 10

}]).then(data => console.log('b: ',data))

});

I can see the data points in the console. How do I retrieve the data points to two different variables?

Re: Mashup to retrieve values from a single row straight table

ErikWetterberg — Thu, 08 Nov 2018 18:43:01 GMT

HI,

something like:

var row = data[0].qMatrix[0];

var x1 = row[0].qNum;

etc....

Erik

‌

Re: Mashup to retrieve values from a single row straight table

jerryhelms2017 — Fri, 09 Nov 2018 13:37:32 GMT

Thank you very much for your help. I am pretty new to Javascript and it is not clear to me where I would place your suggested code to retrieve the values.

Re: Mashup to retrieve values from a single row straight table

ErikWetterberg — Thu, 15 Nov 2018 14:52:51 GMT

Try the place where you log the data today.

Re: Mashup to retrieve values from a single row straight table

dannyy81 — Wed, 16 Oct 2019 14:15:24 GMT

you could use variable.setStringValue method to assign value into script variable :

app.variable.setStringValue("variable", value);