topic Re: Sorting based on Date and Region in App Development

How to Sort based on Date and within date, sort by region in Qlik Sense

rammuthiah — Fri, 09 Sep 2022 06:21:02 GMT

Hi,

I have date and region and have to sort based on date and within date sort by region

Region order would be EU, NA, and AP for each date. This I need to sort in the script

Input:

Date	Region	Count
5/10/2022	AP	3
5/12/2022	AP	6
5/10/2022	EU	2
5/11/2022	EU	2
5/12/2022	EU	9
5/10/2022	NA	3
5/10/2022	NA	4
5/11/2022	NA	1

Output be like below:

Date	Region	Count
5/10/2022	EU	2
5/10/2022	NA	3
5/10/2022	NA	4
5/10/2022	AP	3
5/11/2022	EU	2
5/11/2022	NA	1
5/12/2022	EU	9
5/12/2022	AP	6

Re: Sorting based on Date and Region

MayilVahanan — Wed, 25 May 2022 05:32:04 GMT

Hi
Try like below

Re: Sorting based on Date and Region

rammuthiah — Wed, 25 May 2022 05:52:58 GMT

Thank you, Mayil Vahanan. This I need to sort in the script.

Re: Sorting based on Date and Region

MayilVahanan — Wed, 25 May 2022 05:59:47 GMT

Try like below

Temp:
Load *, Match(Region, 'EU', 'NA', 'AP') as RegionSort Inline
[
Date Region Count
5/10/2022 AP 3
5/12/2022 AP 6
5/10/2022 EU 2
5/11/2022 EU 2
5/12/2022 EU 9
5/10/2022 NA 3
5/10/2022 NA 4
5/11/2022 NA 1
](delimiter is ' ');

Final:
NoConcatenate
Load * resident Temp order by Date, RegionSort;

Drop Table Temp;

Re: Sorting based on Date and Region

rammuthiah — Wed, 25 May 2022 07:19:01 GMT

I have formatted the date and used Id for region and it works.