Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
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
ErikWetterberg

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

Not applicable
Author

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,

shneior_dicastr
Contributor
Contributor

Hi Miguel,

try this

define( [], function () {

    'use strict';

    return {

        qHyperCubeDef: {

            qDimensions: [],

            qMeasures: [],

  qInterColumnSortOrder : [0,1],

            qInitialDataFetch: [

                {

                    qWidth: 10,

                    qHeight: 50

                }

            ]

        }

    };

} );