Sorting HyperCube

salezian — Tue, 11 Feb 2020 12:44:06 GMT

Dear Qlik Fans,

I'm struggling to get sorted alphabetically table in my mashup project.

I'm using following piece of code to get qTable object:

$scope.table=app.createTable([{'qDef':{'qFieldDefs':['Absence Type']},'qSortCriterias':[{'qSortByAscii':1}]}],[],{rows:$scope.pageSize})

but the values are displayed in some random order. Output I'm getting

Other Absence

Special Absence

Not Applicable

Annual Absence

What I've observed is that values are sorted by qElemNumber.

Any help appreciated

Marcin.

Re: Sorting HyperCube

salezian — Tue, 11 Feb 2020 13:13:29 GMT

Ok, I've messed up with code. Code below works fine:

var name= { "qDef": { "qFieldDefs": ["Name"], "qSortCriterias": [{ "qSortByAscii": 1 }], "autoSort": false } } $scope.table=app.createTable([name],[],{rows:$scope.pageSize})

topic Re: Sorting HyperCube in Integration, Extension & APIs

Sorting HyperCube

Re: Sorting HyperCube