Discussion Board for collaboration related to QlikView App Development.
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,
now i want to find date associated to that peak and bottom value.
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)
firstsortedvalue is not working in my case for maximum and minimum it is giving me same result
And why is that? For example, are you using DATE or TYPE as dimensions in your object?