Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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 II
Specialist II

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