Discussion Board for collaboration on QlikView Scripting.
I have a set of data I need to visualize the peak value of the report and date of the value . I'm using the crosstable
How can I visualize the peak value in the above data set as well as the peak value date?
The more information you give the more accurate answer you get.
May be like this:
Dimension : Location
Exp (Peak Value) : Max(Value)
Exp (Date of Peak Value) : FirsSortedValue( Date, - Aggr(Sum(Value), Date,Location))
What output you are expecting to see
Thank you for your time.... get the peak value of the set.. is Max(value) is correct
but I would love to know the date when the peak value occured ... the second expression didnt deliver that..
but I would love to know the date when the peak value occured