Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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})