7 Replies Latest reply: Aug 24, 2018 6:47 AM by Vegard Bakke RSS

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

    Vegard Bakke

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

      However, the expression is always returning blank:

       

        1. 0:{qText: "01", qNum: 1, qElemNumber: 0, qState: "O", qFrequency: "0.233931"}
        2. 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".