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.
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.
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.
