How to order the excel sheets while using page

myself — Fri, 15 Nov 2024 21:26:48 GMT

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?

Re: How to order the excel sheets while using page

Lech_Miszkiewicz — Tue, 08 Aug 2023 00:39:47 GMT

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

topic Re: How to order the excel sheets while using page in Qlik NPrinting

How to order the excel sheets while using page

Re: How to order the excel sheets while using page