topic Re: Date when a min value occurred in QlikView

Date when a min value occurred

sqlpuzzle — Wed, 25 Nov 2020 16:16:04 GMT

I need to find the date on which the Minimum value of a measure happened.

= Min({<Close = {"$(=Min({<Close = {'*'}>}))"}>} begindate)

But not working sample attaced.

Anil_Babu_Samineni — Wed, 25 Oct 2017 15:42:11 GMT

Which object we need to look?

vishsaggi — Wed, 25 Oct 2017 15:44:38 GMT

Where did you use this expression? Or you want to create a new textbox with this expression? What should be your expected output. ?

its_anandrjs — Wed, 25 Oct 2017 15:50:36 GMT

In text object write

=Only({<begindate = {"$(=Min({<Close = {'*'}>}[begindate]))"}>} begindate)

its_anandrjs — Wed, 25 Oct 2017 15:53:17 GMT

Maybe like attached with two new text objects.

vishsaggi — Wed, 25 Oct 2017 15:53:17 GMT

May be try this?

= FirstsortedValue( Date(begindate), Aggr(Min(Close), begindate, Close))

sqlpuzzle — Wed, 25 Oct 2017 16:21:16 GMT

Changing the Min to Max will give the Max Date?

vishsaggi — Wed, 25 Oct 2017 16:24:20 GMT

Yes, like use - minus to aggr.

= FirstsortedValue( Date(begindate), -Aggr(Max(Close), begindate, Close))

its_anandrjs — Wed, 25 Oct 2017 16:34:15 GMT

Dear Joe but what about your condition that you suggest in your question this is not in your expression.

= Min({<Close = {"$(=Min({<Close = {'*'}>}))"}>} begindate)

sqlpuzzle — Wed, 25 Oct 2017 17:08:53 GMT

My expression is wrong..

I need to get the date where the min value of the measure occurred.