topic Re: Sorting Issue in Current Selection Box. in QlikView

Sorting Issue in Current Selection Box.

Wed, 28 Nov 2012 21:24:18 GMT

Guys here is my issue:

I have filter called Country.I am using a mulitbox for this in which I have sorfted it TEXT "A-Z".

List of countires has been sorted in the multibox but the values of the same field "country" in not sorted in the Current selection box.

Why is it so?

I have attached two imges for your review: One from Multibox and one from Current Selection Box.

Please advise.

Thanks,

Re: Sorting Issue in Current Selection Box.

Gysbert_Wassenaar — Thu, 29 Nov 2012 09:14:44 GMT

As far as I know the currentselections box sorts the data in the order it was loaded. Unfortunately there seems to be no way to change the sorting order in the currentselections box other than doing the sorting in the load script.

Re: Sorting Issue in Current Selection Box.

Thu, 29 Nov 2012 17:11:56 GMT

How can I sort the values in script statement/load script?

Re: Sorting Issue in Current Selection Box.

Gysbert_Wassenaar — Thu, 29 Nov 2012 17:45:55 GMT

Use an order by clause:

Temp:

Load Region, SalesPerson, Date, Product, Amount, Sales

from test.qvd (qvd);

Result:

Load * resident Temp

order by Region, SalesPerson, Date desc;

Drop Table Temp;

This will sort the data loaded from test.qvd first by Region ascending and SalesPerson ascending and then by Date descending.

edit: fixed a mistake using order by on a non-resident table

Re: Sorting Issue in Current Selection Box.

Thu, 29 Nov 2012 18:20:27 GMT

Can you send me an example of that?

I have mulitple fields in one QVD and I just want to sort only one field not the complete set of data. How I can write a loda statment for only one field?

Thanks,

Re: Sorting Issue in Current Selection Box.

Mon, 11 Feb 2013 08:08:58 GMT

Hi Gysbert,

I have the same problem.

So I tried your advise. But , unfortunately it did not work for me.

My script is:

TempNetworkDomainData:

LOAD *

FROM D:\QlikView\YbrantDigital\Qvd\sql_data\DAILY_ADX_4_2_2013.qvd(qvd) order by company;

concatenate

LOAD *

FROM D:\QlikView\YbrantDigital\Qvd\sql_data\DAILY_RA_4_2_2013.qvd(qvd) order by company;

I wanted to order by company, because it is not sorted in current selection despite the fact it is sorted in multi selection.

But while I reload the model I am getting error :

Garbage after statement

TempNetworkDomainData:

LOAD *

FROM D:\QlikView\YbrantDigital\Qvd\sql_data\DAILY_ADX_4_2_2013.qvd(qvd) order by company

What should I do?

Thanks,

Inna.

Re: Sorting Issue in Current Selection Box.

Gysbert_Wassenaar — Tue, 12 Feb 2013 19:12:06 GMT

Inna, I made a mistake. Order by can only be done on a resident load. So first load your data into a table and then do another resident load from that table with the order by clause. I've fixed the code above.

Re: Sorting Issue in Current Selection Box.

Wed, 29 Apr 2015 10:02:34 GMT

Sorting in selection box is controlled by settings in [Document Properties/Sort]

Re: Sorting Issue in Current Selection Box.

t_witzgall — Mon, 17 Oct 2016 15:34:38 GMT

Thanks a lot, Jerrik.

This solved our problem!

Re: Sorting Issue in Current Selection Box.

pravinkumar_s — Thu, 17 Jan 2019 12:02:28 GMT

Where can I find that in Qliksense? In Qliksense it is always alphabetically sorted.