topic Re: Find max value within a date range in QlikView

Find max value within a date range

Anonymous — Wed, 13 Jul 2016 19:51:11 GMT

Hello,

I'm trying to find the max value within a certain date range that I have set dynamically using set analysis.

For example, in the table below I have a date range, set to go back a certain amount of days based on the max date, along with the individual sums for those days.

What I'm trying to figure out is how to get the max value for the date range.

Date	7/10/2016	7/9/2016	7/8/2016	7/7/2016	7/6/2016	7/5/2016	7/4/2016	7/3/2016
individual	433	232	312	321	452	432	292	444
max	452	452	452	452	452	452	452	452

Any ideas?

Thank you for your help.

Re: Find max value within a date range

sunny_talwar — Wed, 13 Jul 2016 19:54:02 GMT

May be like this:

Max(TOTAL {<YourSetAnalysis>} individual)

Here YourSetAnalysis and individual are placeholders and replace them with what you have for set analysis and fieldname, respectively

Re: Find max value within a date range

Anonymous — Wed, 13 Jul 2016 20:08:37 GMT

Thank you for the reply Sunny. This is close I feel, however the "individual" values are the result of a SUM function, which doesn't appear to work with MAX before it:

max(total sum({<Set Analysis>} individual))

Re: Find max value within a date range

sunny_talwar — Wed, 13 Jul 2016 20:10:49 GMT

How about this:

Max(TOTAL Aggr(Sum({<YourSetAnalysis>} individual), Date))

Re: Find max value within a date range

Anonymous — Wed, 13 Jul 2016 20:16:41 GMT

That works!! Thank you so much Sunny!!