topic Re: Problem with qInterColumnSortOrder in Integration, Extension & APIs

Problem with qInterColumnSortOrder

Thu, 04 Feb 2016 09:23:47 GMT

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!

Re: Problem with qInterColumnSortOrder

ErikWetterberg — Fri, 05 Feb 2016 07:19:32 GMT

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

Re: Problem with qInterColumnSortOrder

Fri, 05 Feb 2016 07:27:21 GMT

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/Overview/qHyperCubeDef.h…

Regards,

Re: Problem with qInterColumnSortOrder

shneior_dicastr — Tue, 24 Jan 2017 19:23:35 GMT

Hi Miguel,

try this

define( [], function () {

'use strict';

return {

qHyperCubeDef: {

qDimensions: [],

qMeasures: [],

qInterColumnSortOrder : [0,1],

qInitialDataFetch: [

{

qWidth: 10,

qHeight: 50

}

]

}

};

} );