topic GetLayout/GetProperties on mashup missing measure/dimension definitions in Integration, Extension & APIs

GetLayout/GetProperties on mashup missing measure/dimension definitions

josecardenas — Thu, 05 Nov 2015 16:53:08 GMT

Hi.

I'm working on a mashup on qliksense v 2.0.4 and the idea is create a cube based on a previous table already build in the application.

I'm getting the layout or properties using the respective mashup API's. So I open the app then get the properties and take the layout json definition. Everything is alright, but when I've got the json result object on gGroupFielDefs section is displaying the fields without the set expressions; set expressions defined in the app. So when I've tried to place that definitions in the new cube is failing.

The Fields on the app are:

Dimensions:

Label: Word

Field Definition: Aggr(Only({<FreeTextQuestionUniqueId = {'{35563651-BFBC-40C7-BC1D-01D6BC193A43}'}, PrevDayStarted = {1}>} ResponseWord ), ResponseWord)

When I've getting the info on the mashup the qGroupFiledDefs is:

"qGroupFieldDefs": [ "=Aggr(Only({} ResponseWord ), ResponseWord)" ]

As you can see no set expression between {} as was defined in the app: <FreeTextQuestionUniqueId = {'{35563651-BFBC-40C7-BC1D-01D6BC193A43}'}, PrevDayStarted = {1}>

When I've gotten using the workbench I'm getting something like:

"qDimensionInfo": [ { "qFallbackTitle": "Word", "qApprMaxGlyphCount": 15, "qCardinal": 114, "qSortIndicator": "A", "qGroupFallbackTitles": [ "Word" ], "qGroupPos": 0, "qStateCounts": { "qLocked": 0, "qSelected": 0, "qOption": 0, "qDeselected": 0, "qAlternative": 0, "qExcluded": 0, "qSelectedExcluded": 0, "qLockedExcluded": 0 }, "qTags": [], "qDimensionType": "D", "qGrouping": "N", "qNumFormat": { "qType": "U", "qnDec": 10, "qUseThou": 0 }, "qIsAutoFormat": true, "qGroupFieldDefs": [ "=Aggr(Only({} ResponseWord ), ResponseWord)" ], "autoSort": true, "cId": "jDhVNCJ", "othersLabel": "Others", "textAlign": { "auto": true, "align": "left" } } ]

The same issue. No set expressions.

What I'm doing wrong? ... Do I need call another function mashup API in order to get the full expression?

I really appreciate your help!

Jose

Re: GetLayout/GetProperties on mashup missing measure/dimension definitions

ErikWetterberg — Fri, 06 Nov 2015 07:20:29 GMT

Layout and properties are two different structures: properties contains expressions etc, while layout contains the calculated values. For rendering you need layout, and your json looks like the layout, but in your case you would need to get the properties.

Erik

Re: GetLayout/GetProperties on mashup missing measure/dimension definitions

josecardenas — Fri, 06 Nov 2015 09:15:38 GMT

Thanks Erik for your quickly answer

Unfortunately, I'm getting the same result with the properties. A chunk below:

{

"jsonrpc": "2.0",

"id": 3,

"result": {

"qProp": {

"qInfo": {

"qId": "YMqmSP",

"qType": "table"

"qMetaDef": {},

"qHyperCubeDef": {

"qDimensions": [

{

"qDef": {

"qGrouping": "N",

"qFieldDefs": [

"=Aggr(Only({} ResponseWord ), ResponseWord)"

"qFieldLabels": [

"Word"

"qSortCriterias": [

{

"qSortByLoadOrder": 1,

"qExpression": {}

}

"qNumberPresentations": [],

"qActiveField": 0,

"autoSort": true,

"cId": "jDhVNCJ",

"othersLabel": "Others",

"textAlign": {

"auto": true,

"align": "left"

}

"qNullSuppression": true,

"qOtherTotalSpec": {

"qOtherMode": "OTHER_OFF",

"qOtherCounted": {

"qv": "10"

"qOtherLimit": {

"qv": "0"

"qOtherLimitMode": "OTHER_GE_LIMIT",

"qForceBadValueKeeping": true,

"qApplyEvenWhenPossiblyWrongResult": true,

"qOtherSortMode": "OTHER_SORT_DESCENDING",

"qTotalMode": "TOTAL_OFF",

"qReferencedExpression": {}

"qOtherLabel": {},

"qTotalLabel": {},

"qCalcCond": {}

}

]

....

Re: GetLayout/GetProperties on mashup missing measure/dimension definitions

ErikWetterberg — Fri, 06 Nov 2015 14:19:19 GMT

Looks like a bug, please report it.

Erik