3 Replies Latest reply: Jun 12, 2018 5:31 AM by Humeshkumar Sindpure RSS

    Sorting dimension fields in mashup qHyperCube

    Tuomas Lammi

      Hi,

      I have a hypercuby like this (just part of it):

       

       

      {

       

         "qDef": {

         "qFieldDefs": [

         "ISO Code"

        ]

        },

         "qNullSuppression": true,

         "qOtherTotalSpec": {

         "qOtherMode": "OTHER_OFF",

         "qSuppressOther": true,

         "qOtherSortMode": "OTHER_SORT_DESCENDING",

         "qOtherCounted": {

         "qv": "5"

        },

         "qOtherLimitMode": "OTHER_GE_LIMIT"

        }

        },

       

      How can I add a ascending sort by expression to a dimension? For measures, the qhypercube editor adds an sort object but for dimensions theres no option like that. In qlik sense editor, I can do it like this:

      expressionsort.PNG

       

       

      Any ideas? Thanks in advance.

       

      // T