Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Mukesh_s
Contributor II
Contributor II

Get rows with most recent quarter by grouping values in another column

Hi Everyone, I am trying to get the rows with recent Quarter for each value in col 1.

Example I have data as below

Col 1 Col 2
A 2022Q1
A 2022Q4
B 2023Q1
B 2022Q2

 

I want to get the data as below with 

Col 1 Col 2
A 2022Q4
B 2023Q1

 

Thanks in advance.

Labels (5)
1 Reply
henrikalmen
Specialist
Specialist

Try a table with dimension [Col 1] and measure maxstring([Col 2])