Announcements
Applications are open for the 2024 Qlik Luminary Program. Apply by December 15 here.
cancel
Showing results for
Did you mean:
Anonymous
Not applicable

## Get the date of min and max value

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,

1 Solution

Accepted Solutions

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://qlikviewcookbook.com

http://www.easyqlik.com

5 Replies
Specialist II

Hi

you may have tie values,

in that case firstsortedvalues return null

regards

Partner - Champion

maybe this:

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

I hope it helps.

Anonymous
Not applicable
Author

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!

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://qlikviewcookbook.com

http://www.easyqlik.com

Anonymous
Not applicable
Author

That worked:

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

Thank you!

Tags
Community Browser