Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How can I calculate a max per period of maximums per day

Hello,

I'm looking for a solution regarding the following problem. For a number of intervals a day I'm calculating a sum, in another expressions i'm calculating the maximum score of those intervals. Now I would like to know the maximum score for a particular period (in my case periods are months).

An example

Voorbeeld max max.JPG

Using the sum to determine the score per day makes the maximum expression useless when not using the date dimension (since I do want the maximum per day score). The score I would like to get in the example is 4 (so far I'm getting 6 > maximum of the sum of interval 3). Any suggestions? (If there is a better solution for finding the maximum score per day this would be helpfull as well).

Regards,

Raimund

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Try a straight table chart with dimension Day and as expression

=rangemax( sum(Interval1), sum(Interval2), sum(Interval3) )

and to get the maximum across all days in a e.g. text box

=max( aggr( rangemax( sum(Interval1), sum(Interval2), sum(Interval3) ) , Day))

View solution in original post

2 Replies
swuehl
MVP
MVP

Try a straight table chart with dimension Day and as expression

=rangemax( sum(Interval1), sum(Interval2), sum(Interval3) )

and to get the maximum across all days in a e.g. text box

=max( aggr( rangemax( sum(Interval1), sum(Interval2), sum(Interval3) ) , Day))

Not applicable
Author

Many thanks for the formulas, both work fine!