Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
]
;
cheers
Lech
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
]
;
cheers
Lech