Another option would be to sort the data client side. This is pretty straight forward in QlikView because the data comes as a multi-dimensional array. Something like this -
sortData(1, "asc);
function sortData(colIndex, order){
var aWin = order=="asc"?1:-1;
var bWin = aWin * -1;
_this.Data.Rows.sort(function(a,b){
if(a[colIndex].text > b[colIndex].text){
return aWin;
}
else if (a[colIndex].text < b[colIndex].text) {
return bWin;
}
else{
return 0;
}
});
}
If you need to sort by more than 1 column then you'll need to expand on this logic.
thanks for your reply. Yes I know it´s possible to sort on the client side. But you have many rows to sort for example 50.000 and more it´s to much on the client side. I think the best way is to sort it by qlikview server and you get the sortet result set. I hope I find anyone a good solution.
