topic Re: FirstSortedValue in QlikView

FirstSortedValue

r_vdbraak — Tue, 01 Jul 2014 18:03:05 GMT

Dear Qlikview Friends,

I want to select the last date with the highest Koers.

I use this code:

tmpDir:

LOAD

FirstSortedValue(Datum, -Koers) AS DatumHoogsteKoers

Resident Koersen

Order By Datum asc;

This code works fine except when there are more dates with the same highest Koers

Who can help me.

Gysbert_Wassenaar — Tue, 01 Jul 2014 18:11:54 GMT

tmpKoersen:

Load Datum, Koers

From ...

join (tmpKoersen)

Load Datum, max(Koers) as Koers, 1 as Flag

Resident tmpKoersen;

Result:

Load max(Datum) as DatumHoogsteKoers

Resident tmpKoersen

Where Flag =1;

r_vdbraak — Wed, 02 Jul 2014 14:04:59 GMT

Gysbert,

Thanks for your reaction.

I will try to fix it with your solution.

r_vdbraak — Wed, 16 Jul 2014 13:24:25 GMT

Gysbert,

With your suggestion I created this solution.

//Hoogste koers

tmpKoers:

LOADMax(Koers) AS KoersMax

Resident Koersen;

//Datum hoogste koers

tmpDatum:LOADMax(Datum) AS DatumHoogsteKoers

Resident Koersen

Where Koers = NUM(PEEK('KoersMax' , 0, 'tmpKoers'));

LET vDatumHoogsteKoers = NUM(PEEK('DatumHoogsteKoers' , 0, 'tmpDatum'));