Top row using date fields(select the latest date)

[TheresaB_4]

Hi everyone,

In SQL you can use ROW_NUMBER() to get the top row sorting desc
How do we do this in Qlik Sense?
I have a meter Reading, but with several lines and MeterReadDate. I only want it to show the latest ReadingDate.
I have tried using Max but it still shows multiple lines.

Account	Profiel	Meternummer	High-Low	meterdate	ReadingDate	MeterRead	previous Meter read
871687120055493509	_2A	ZASN009683167610	High	17/10/2023	07/11/2023	312433	284233
871687120055493509	_2A	ZASN009683167610	High	01/01/2023	02/11/2023	269764	242421
871687120055493509	_2A	ZASN009683167610	High	01/04/2023	05/04/2023	284233	269764
871687120055493509	_2A	ZASN009683167610	High	01/07/2022	16/02/2023	242421	228699
871687120055493509	_2A	ZASN009683167610	High	11/10/2021	16/02/2023	228699	228698

[Ahidhar]

use Order By ReadingDate desc;

[jochem_zw · Accepted solution]

Remove the readingdata as a dimension from your table and add it to a table (chart) as a expression like below: 

=Only({$<ReadingDate={"$(=Date(Max(Total ReadingDate),'DD/MM/YYYY'))"}>}ReadingDate)

[TheresaB_4]

Thank you so much