Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
josecardenas
Contributor III
Contributor III

GetLayout/GetProperties on mashup missing measure/dimension definitions

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

3 Replies
ErikWetterberg

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

josecardenas
Contributor III
Contributor III
Author

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": {}

     }

    ]

....