Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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

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

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

2 Replies
MVP
MVP

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

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

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

Many thanks for the formulas, both work fine!

Community Browser