Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
thanks for reply. please see attached sample qvf.
Basically i need the lastest day -1 (prior day) price.