Get the date of min and max value

[Anonymous]

Hi everyone,

Another question for you.

In my pivot table I'd like to display the date of my min and max values.

I tried the following:

(Min)=FirstSortedValue([Date],[Resultat])

(Max)=FirstSortedValue([Date],-[Resultat])

But I'm not getting exactly what I want... here's an example

So as you can see and I have a min and max value for each row. But some dates are unexpectedly missing and I don't understand why.

Would someone have a hint?

Thanks,

[ogautier62]

Hi

you may have tie values,

in that case firstsortedvalues return null

regards

[agigliotti]

maybe this:

=FirstSortedValue( Date, Aggr( Sum(Resultat), Date ) )

I hope it helps.

[Anonymous]

You are right.

I have multiple times the same min and the same max.

So what if I want the minimum date among my minimum values?

Thanks!

[rwunderlich · Accepted solution]

You can try:

(Min)=FirstSortedValue(DISTINCT [Date],[Resultat])

to see if it gives the right result. Or explicitly add a bias to get the min date when there is a tie.

(Min)=FirstSortedValue([Date],[Resultat] + (Date * 0.0001))

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

http://www.easyqlik.com

[Anonymous]

That worked:

=FirstSortedValue([Date],[Resultat] + (Date * 0.0001))

Thank you!