Pivot Table

[qlikapple]

Region	Country	Year	Month
Asia Pacific	Philippines	2019	Aug
Asia Pacific	Philippines	2019	Dec
Asia Pacific	Philippines	2019	Jul
Asia Pacific	Philippines	2019	Oct
Asia Pacific	Philippines	2019	Sep
Asia Pacific	Philippines	2020	Jan
Europe	UK HSBC	2019	Apr
Europe	UK HSBC	2019	Aug
Europe	UK HSBC	2019	Dec
Europe	UK HSBC	2019	Jul
Europe	UK HSBC	2019	June
Europe	UK HSBC	2019	May
Europe	UK HSBC	2019	Nov
Europe	UK HSBC	2019	Oct
Europe	UK HSBC	2019	Sep
Europe	UK HSBC	2020	Jan
Europe	UK FD	2019	Aug
Europe	UK FD	2019	Dec
Europe	UK FD	2019	Jul
Europe	UK FD	2019	June
Europe	UK FD	2019	May
Europe	UK FD	2019	Nov
Europe	UK FD	2019	Oct
Europe	UK FD	2019	Sep
Europe	UK FD	2020	Jan
Europe	UK MSB	2019	Aug
Europe	UK MSB	2019	Jul
Europe	UK MSB	2019	June
Europe	UK MSB	2019	Nov
Europe	UK MSB	2019	Oct
Europe	UK MSB	2019	Sep
Europe	UK MSB	2020	Jan
Europe	UK JLFS	2019	Aug
Europe	UK JLFS	2019	Jul
Europe	UK JLFS	2019	Nov
Europe	UK JLFS	2019	Oct

I need the  table as 

Region	Country	Min to Max
Asia Pacific	Philippines	2019 Jul-2020 Jan
Europe	UK HSBC	2019 Apr-2020 Jan

can anyone please help me on this

[qlikapple]

anyone please look into this

[sunny_talwar]

Try this

Table:
LOAD Region,
	 Country,
	 Date(Min(YearMonth), 'YYYY MMM') & ' - ' & Date(Max(YearMonth), 'YYYY MMM') as [Min to Max]
Group By Region, Country;
LOAD Region,
	 Country,
	 Year,
	 Month(Date#(Month, 'MMM')) as Month,
	 Date(MakeDate(Year, Month(Date#(Month, 'MMM'))), 'YYYY MMM') as YearMonth;
LOAD * INLINE [
    Region, Country, Year, Month
    Asia Pacific, Philippines, 2019, Aug
    Asia Pacific, Philippines, 2019, Dec
    Asia Pacific, Philippines, 2019, Jul
    Asia Pacific, Philippines, 2019, Oct
    Asia Pacific, Philippines, 2019, Sep
    Asia Pacific, Philippines, 2020, Jan
    Europe, UK HSBC, 2019, Apr
    Europe, UK HSBC, 2019, Aug
    Europe, UK HSBC, 2019, Dec
    Europe, UK HSBC, 2019, Jul
    Europe, UK HSBC, 2019, June
    Europe, UK HSBC, 2019, May
    Europe, UK HSBC, 2019, Nov
    Europe, UK HSBC, 2019, Oct
    Europe, UK HSBC, 2019, Sep
    Europe, UK HSBC, 2020, Jan
    Europe, UK FD, 2019, Aug
    Europe, UK FD, 2019, Dec
    Europe, UK FD, 2019, Jul
    Europe, UK FD, 2019, June
    Europe, UK FD, 2019, May
    Europe, UK FD, 2019, Nov
    Europe, UK FD, 2019, Oct
    Europe, UK FD, 2019, Sep
    Europe, UK FD, 2020, Jan
    Europe, UK MSB, 2019, Aug
    Europe, UK MSB, 2019, Jul
    Europe, UK MSB, 2019, June
    Europe, UK MSB, 2019, Nov
    Europe, UK MSB, 2019, Oct
    Europe, UK MSB, 2019, Sep
    Europe, UK MSB, 2020, Jan
    Europe, UK JLFS, 2019, Aug
    Europe, UK JLFS, 2019, Jul
    Europe, UK JLFS, 2019, Nov
    Europe, UK JLFS, 2019, Oct
];

[Brett_Bleess]

Did Sunny's post help you get what you needed for your use case?  If so, do not forget to return to your thread and on his post, use the Accept as Solution button to mark it giving him credit for the help and letting other Members know that worked.  If you did something else, please consider posting that and then mark it to close out the thread, and if you are still working on things, please leave an update with what you still need.

Regards,
Brett