topic Re: Sort in particular order in dimension in QlikView

Sort in particular order in dimension

Anonymous — Mon, 26 Jan 2026 18:19:17 GMT

Hi,

I have three dimension . date , country and populations. i want to make a pivot table and have atleast 20 country. i want to sort them at a particular order. such as US, india , indonesia, canada, brazil..... how can i accompolsihed this in qlikview.

Thanks,

Samay

Sort in particular order in dimension

Mon, 04 Jul 2011 12:11:03 GMT

Hi,

Option is there in "Sort tab"

Regards,

Sri

Re: Sort in particular order in dimension

nagaiank — Mon, 04 Jul 2011 22:55:03 GMT

You may load Country as a dual field and define the numeric sort order for the country name string as follows and then sort country field by numeric ascending/descending.

load dual (string,numrep) as Country inline [

string,numrep

US,0

India,1

Indonesia,2

Canada,3

Brazil,4

...

];

If you have a large number countries, you may load the above data from a spreadsheet, external text file or database file if necessary.

Hope this helps.

Sort in particular order in dimension

Anonymous — Tue, 05 Jul 2011 04:44:08 GMT

HI Krishna,

Thanks. it really works.

Thanks,

samay