Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
akpofureenughwu
Contributor III

Peak Value to Date

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

Location01/01/201602/01/201603/01/2016
Area 1100200050

How can I visualize the peak value in the above data set as well as the peak value date?

Regards         

4 Replies
MVP
MVP

Re: Peak Value to 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))

Re: Peak Value to Date

What output you are expecting to see

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
akpofureenughwu
Contributor III

Re: Peak Value to Date

tresesco

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..

regards

akpofureenughwu
Contributor III

Re: Peak Value to Date

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