Qlik Community

Qlik Sense Integration, Extensions, & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

Not applicable

Problem with qInterColumnSortOrder

Hello,

While creating a new extention I am trying to use qInterColumnSortOrder in the initialProperties of a HyperCube but when I introduce any value in the brackets:

initialProperties: {

      qHyperCubeDef: {

        qDimensions: [],

        qMeasures: [],

       qInterColumnSortOrder: [1,2,0],

        qInitialDataFetch : [{

          qWidth : 10,

          qHeight : 1000

        }]

      }

    },

I get the error: Invalid sort order in properties.

Does anybody know why this is happening?

Thank you in advance!

3 Replies
erik_wetterberg
Valued Contributor III

Re: Problem with qInterColumnSortOrder

Hi Miguel,

I haven't tested this, but this is probably because you have no dimensions and measures only qInterColumnSortOrder, which means that the values 0,1,2 will point outside the arrays of dimensions and measures, which is illegal.

Hope this helps

Erik

Erik Wetterberg
https://extendingqlik.upper88.com/
Not applicable

Re: Problem with qInterColumnSortOrder

Hi Erik,

I'm not sure if that is the problem... If you take a look to the documentation you will find this:

initialProperties : {

     version : 1.0,

     qHyperCubeDef : {

          qDimensions : [],

          qMeasures : [],

          qInterColumnSortOrder : [1,0]

          qInitialDataFetch : [{ qWidth : 10, qHeight : 50

          }]

     }

},


Here is the link where I found that:


https://help.qlik.com/sense/1.1/en-us/developer/Subsystems/Workbench/Content/BuildingExtensions/Over...

Regards,

Highlighted
shneior_dicastr
New Contributor

Re: Problem with qInterColumnSortOrder

Hi Miguel,

try this

define( [], function () {

    'use strict';

    return {

        qHyperCubeDef: {

            qDimensions: [],

            qMeasures: [],

  qInterColumnSortOrder : [0,1],

            qInitialDataFetch: [

                {

                    qWidth: 10,

                    qHeight: 50

                }

            ]

        }

    };

} );