How to order the excel sheets while using page

[myself]

Hi, 

      I was using page for creating multiple sheets for all the countries present in my  field 'REGION'. I want the sheets to be appearing in one specific order of countries.  I have also seen one solution for the similar question that was posted before but if i use that solution, then the sheets will be named not as country names but just numbers.

    The solution that they have mentioned is in the below link

Solved: How to sort the way Pages appears ? - Qlik Community - 1269550 

Can anyone provide a proper working solution so that countries appear in the specific order i want in the sheets?

[Lech_Miszkiewicz · Accepted solution]

The method I use is to convert field to Dual() for example:

	Load 
    	Dual(Page_Field_temp,Page_Field_Id) as Page_Field
    Inline
    	[
        	Page_Field_temp,Page_Field_Id
            B,1
            A,2
            C,3
        ]
        ;

Then when using this field in Page of the excel it seems to retain numerical order. of the sort

cheers

Lech