Need help to display sorted sheet name in drop-down list

Anonymous — Thu, 23 Mar 2017 06:26:07 GMT

Hi,

QlikSense - I am facing issues while displaying sheet name in drop-down list in proper order. Below is the code which shows the sheet name but in random order and not in ascending or descending order. Can anyone help, doing this please? FYI, I have got this code from existing custom extension.

----------------------------------------------------------------

app.getAppObjectList("sheet",function(reply)

{

console.log(reply);

var str = "";

$.each(reply.qAppObjectList.qItems, function(key, value)

{

str += value.qData.title + ' ';

if(currUrl.search("analysis") >-1)

{

html += '<option value="' + urlPath + value.qInfo.qId + '/state/analysis">' + value.qData.title + '</option>';

}

else

{

html += '<option>' + value.qData.title + '</option>';

}

cnt+=1;

});

html+= "</select></fieldset></form></div>";

$element.html( html );

$(function(){

$('.dropdown').click(function(){

$('#sheetList').change(function(){

var value = $(this).val();

window.location.href = value;

})

--------------------------------------------------------

Thanks,

Kranti

Re: Need help to display sorted sheet name in drop-down list

Anonymous — Fri, 26 May 2017 06:26:15 GMT

I could able to complete this task. See if it can be useful for others.

app.getList("sheet",function(reply)

{

$.each(reply.qAppObjectList.qItems, function(key, value)

{

temp.push({v:value, k: key});

});

temp.sort(function(a,b){

if(a.v.qData.description > b.v.qData.description){ return 1}

if(a.v.qData.description < b.v.qData.description){ return -1}

return 0;

});

temp.sort(function(a,b){

if(a.v.qData.title > b.v.qData.title){ return 1}

if(a.v.qData.title < b.v.qData.title){ return -1}

return 0;

});

$.each(temp, function(key, obj) {

currentCat = obj.v.qData.description;

if(currentCat != prevCat){

prevCat = obj.v.qData.description;

html +='<optgroup label="'+obj.v.qData.description+'">';

}

if(currUrl.search("analysis") >-1)

{

html += '<option value="' + urlPath + obj.v.qInfo.qId + '/state/analysis">' + obj.v.qData.title + '</option>';

}

else

{

html += '<option>' + obj.v.qData.title + '</option>';

}

if(currentCat != prevCat){

html +='</optgroup>';

}

});

topic Need help to display sorted sheet name in drop-down list in App Development

Need help to display sorted sheet name in drop-down list

Re: Need help to display sorted sheet name in drop-down list