Discussion Board for collaboration related to QlikView App Development.
Who can help me solving this problem.
I'm using a script to select the value of the lowest Koers and the highest Koers
It works correct as long there are no double Koers values
If there is a double Value I want to select the latest date.
FirstSortedValue(Date, -Koers) AS DateMaxKoers
FirstSortedValue(Date, Koers) AS DateMinKoers
I expect as DateMaxKoers 16-04-2014 11,95
as DateMinKoers 14-04-2014 11,75
Thanks for thinking with me.
When I use Order by Date desc I got what I expect.
Thanks for your help.
The complete script:
Order by Date desc;
View solution in original post
Try using distinct like:
FirstSortedValue( Distinct Date, Koers) AS DateMinKoers
Don't worry about syntax error red mark.
Thanks for your helpful thinking.
Using Distinct gives me a value, but it is the first date (08-04-2014) in stead of the last date (14-04-2014)
User the Order By clause to change the order of load , like:
Load * Inline [
Date, Koers17-04-2014, 11.9116-04-2014, 11.9515-04-2014, 11.8414-04-2014, 11.7511-04-2014, 11.8310-04-2014, 11.7609-04-2014, 11.7708-04-2014, 11.7507-04-2014, 11.94];Fin:Load FirstSortedValue(distinct Date, Koers) as FSVResident Temp order by Date asc;
Example for you with calculations in the script and on the fly.