Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
ENG
Contributor
Contributor

FirstSortedValue with rank not working in QlikSense

while the firstsortedvalue function works ok without rank variable, i need the 2nd rank value.

Script: FirstSortedValue("Last Price",-PX_Date) as LatestPx

After i add the ranking, it gives a null value. 

FirstSortedValue("Last Price",-PX_Date,2) as LatestPx

I tried both in script and chart. Once i add the rank, it doesnt work. Btw, im trying this in qliksense. I have also validated the same script works perfectly in qlikview without problems. can anyone help?

2 Replies
PrashantSangle

Your expression is correct.
can your share sample data or qvf.

Regards,
Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
ENG
Contributor
Contributor
Author

thanks for reply. please see attached sample qvf. 

Basically i need the lastest day -1 (prior day) price.