Hypercube Def : PseudoDimension position not change

simoneantonicchio — Sat, 16 Nov 2024 03:06:50 GMT

Hello,

I'm developing an extension to display a pivot table using an hypercube. Before accomplished this I have created a pivot table into my Qlik sense App to check result that will be cloned into my extension.

The issue is the follow:

I have:

- two dimensions: "Model" and "Country"
- two measures : "FBD" and "LTR"

I wanna obtain this:

But I obtain this in my hypercube:

Below you can see my hypercube def and I think to have setted qInterColumnSortOrder array in the right way.

var myProps = { textColor: "black", qHyperCubeDef: { qDimensions: [], qMeasures: [], qInitialDataFetch: [ { qTop: 0, qLeft: 0, qWidth: 100, qHeight: 300 } ], qInterColumnSortOrder: [0, -1, 1], //qPseudoDimPos:1, qNoOfLeftDims: 2, qMode: "P", qAlwaysFullyExpanded: true, qIndentMode: false } }; var myDefinition = { type: "items", component: "accordion", items: { dimensions: { uses: "dimensions", min: 2, max: 2 }, measures: { uses: "measures", min: 2, max: 2 }, sorting: { uses: "sorting" }, settings: { uses: "settings" } } };

Sometimes will be loaded the columns like my qInterColumnSortOrder , but another in this order: -1,0,1.

I don't know where there is a conflict or other issue.

Have you any idea to solve this?

Thank you all,

Simone

Re: Hypercube Def : PseudoDimension position not change

simoneantonicchio — Thu, 12 Mar 2020 11:37:16 GMT

I have solved using backend-API method "applyPatches".
With this method i replace column order after render.

https://help.qlik.com/en-US/sense-developer/February2020/Subsystems/APIs/Content/Sense_ClientAPIs/BackendAPI/applypatches-method.htm

paint: function($element, layout) { var app = qlik.currApp(); this.backendApi .applyPatches( [ { qPath: "/qHyperCubeDef/qInterColumnSortOrder", qOp: "replace", qValue: "[0,-1,1]" } ], true ) }

topic Hypercube Def : PseudoDimension position not change in Integration, Extension & APIs

Hypercube Def : PseudoDimension position not change

Re: Hypercube Def : PseudoDimension position not change