topic Re: Minimum and Maximum date in QlikView

Minimum and Maximum date

vijetas42 — Mon, 17 Sep 2018 10:28:04 GMT

Hi Team,

I have one data set which have values and dates and also one selection for date

in that i am selecting one date and finding out last 8 weeks date and from that i am getting last 8 weeks dataset

from that i am extracting Peak and bottom value,

=num(max({<DATE={">=$(vPrior8WeekDate)<=$(vCurrentDate)"},TYPE={'ALP'}>}VALUE),'#,##.0')

=num(min({<DATE={">=$(vPrior8WeekDate)<=$(vCurrentDate)"},TYPE={'ALP'}>}VALUE),'#,##.0')

now i want to find date associated to that peak and bottom value.

Re: Minimum and Maximum date

Peter_Cammaert — Mon, 17 Sep 2018 10:37:09 GMT

Have a look at Chart Aggregation Function FirstSortedValue

You can keep the Set analysis expression and use the sort-weight to find the minimum (by default) or the maximum (negate the sort-weight). The first parameter specifies which corresponding field value to return (in your case a date)

Best,

Peter

Re: Minimum and Maximum date

vijetas42 — Wed, 19 Sep 2018 10:36:14 GMT

firstsortedvalue is not working in my case for maximum and minimum it is giving me same result

Re: Minimum and Maximum date

Peter_Cammaert — Thu, 20 Sep 2018 08:03:33 GMT

And why is that? For example, are you using DATE or TYPE as dimensions in your object?