3 Replies Latest reply: Nov 6, 2015 9:19 AM by Erik Wetterberg RSS

    GetLayout/GetProperties on mashup missing measure/dimension definitions

    Jose Cardenas

      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
          Erik Wetterberg

          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
              Jose Cardenas

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

                   }

                  ]

              ....