Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
khouloudgh
Contributor
Contributor

recuperer la dernier valeur avant le max

je veux récupéré la valeur avant du maximum dans ma sql table 

3 Replies
Lauri
Specialist
Specialist

Tu peux essayer:

=FirstSortedValue ([fieldname], -[fieldname], 2)

sergio0592
Specialist III
Specialist III

Ou tout simplement

max(Field,2)

 

Lauri
Specialist
Specialist

Eh ben, sergio0592 a la bonne reponse! Je ne savais pas que max peut specifier 'rank.' Merci.