topic Re: Is it possible to get expressions in a qListObject in a mashup? in Integration, Extension & APIs

Is it possible to get expressions in a qListObject in a mashup?

vegard_bakke — Thu, 24 May 2018 12:20:27 GMT

I've tries setting up a qListObject in a mashup, with one dimension, and one extra expression.

However, the expression is always returning blank:

0:{qText: "01", qNum: 1, qElemNumber: 0, qState: "O", qFrequency: "0.233931"}
1:{qText: "-", qNum: "NaN", qElemNumber: 0, qState: "L"}

The definition I've been trying is this:

app.createList({

"qFrequencyMode": "R",

"qDef": {

"qFieldDefs": [

"RegionNo"

"qSortCriterias": [

{

"qSortByExpression": 1,

"qExpression": {

"qv": "=RegionNo"

}

]

"qExpressions": [

{

"qDef": {

"qDef": "=Count(RegionNo)"

"qLabel": "=Count(RegionNo)",

"qLibraryId": null

}

"qInitialDataFetch": [

{

"qHeight": 20,

"qWidth": 2

}

"qLibraryId": null

},onDataTest);

The current =Count(RegionNo) is just attempt to avoid any mistakes in Qlik expression. Ideally, it should be replaced by =Only(RegionName).
Both return qText: "-", qNum: "NaN".

Re: Is it possible to get expressions in a qListObject in a mashup?

ErikWetterberg — Tue, 29 May 2018 10:48:44 GMT

Hi,

The documentation is sometimes hard to read, but I think it should be:

qExpressions: [
{
 qExpr: "=Count(RegionNo)"
}
]

Please let us know if this helps.

Erik Wetterberg

Re: Is it possible to get expressions in a qListObject in a mashup?

vegard_bakke — Tue, 29 May 2018 11:57:18 GMT

Thank you for your reply!

Unfortunately, qExpr: "=Count(RegionNo)" yields the same result, qText: "-", qNum: "NaN".

The code above is generated by Qlik Sense Feb 2018 SR1, when using the 'Add List' (or 'Add Hypercube'), to the right under Options in Mashup DevHub editor.

I hope that Qlik is generating code that itself understands. But, I guess this is an area that's not used or tested that much, maybe...

Re: Is it possible to get expressions in a qListObject in a mashup?

ErikWetterberg — Tue, 29 May 2018 12:10:05 GMT

Hi,

Didn't realize you used the Mashup Generator, have you tried reporting this as a bug??

Erik Wetterberg

Re: Is it possible to get expressions in a qListObject in a mashup?

ErikWetterberg — Tue, 29 May 2018 12:42:24 GMT

Hi,

You could try with a HyperCube instead. Set qShowAll on the dimension, it should give you all values, like a ListObject.

Erik Wetterberg

Re: Is it possible to get expressions in a qListObject in a mashup?

vegard_bakke — Tue, 29 May 2018 16:03:40 GMT

Thank you, Erik! Your insight is always appreciated!

Here is a fully working "list", with both a RegionNo, and the RegionName.

It is a hypercube, but it returns all rows, not just the selected rows, like a hypercube does by default.

app.createCube({

"qInitialDataFetch": [

{

"qHeight": 20,

"qWidth": 2

}

"qDimensions": [

{

"qDef": {

"qFieldDefs": [

"RegionNo"

]

"qNullSuppression": true,

"qShowAll": true

}

"qMeasures": [

{

"qDef": {

"qDef": "MinString( {< Region=,RegionNo=,RegionName= >} RegionName)"

"qLabel": "Region",

"qLibraryId": null,

"qSortBy": {

"qSortByState": 0,

"qSortByFrequency": 0,

"qSortByNumeric": 0,

"qSortByAscii": 1,

"qSortByLoadOrder": 0,

"qSortByExpression": 0,

"qExpression": {

"qv": " "

}

"qSuppressZero": false,

"qSuppressMissing": false,

"qMode": "S",

"qInterColumnSortOrder": [],

"qStateName": "$"

}, onDataTest);

(Sorry Erik, for marking my own answer as correct. But the full code might be better for other people later. Thanks again!)

Re: Is it possible to get expressions in a qListObject in a mashup?

vegard_bakke — Tue, 29 May 2018 16:05:30 GMT

No, I haven't. Unfortunately, a bug takes longer to get fixed, than making a work around. 😕

Re: Is it possible to get expressions in a qListObject in a mashup?

vegard_bakke — Fri, 24 Aug 2018 10:47:42 GMT

Just an additional comment:

The qShowAll is not enough. There has to be an expression as well.