# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for
Did you mean:
Highlighted
Contributor III

## Max of Multiple Set Analysis values

Hi Everyone,

I am attempting to embed a formula to work out density into Qlik Sense, I broke each section down into individual set analysis scripts as below:

Forklift 1 is =Count({\$<[Short Name]={Forklift 1}>}[%Move Key]) * (Max({\$}Time)-Min({\$}Time))

Forklift 2 is =Count({\$<[Short Name]={Forklift 2}>}[%Move Key]) * (Max({\$}Time)-Min({\$}Time))

Forklift 2 is =Count({\$<[Short Name]={Forklift 3}>}[%Move Key]) * (Max({\$}Time)-Min({\$}Time))

What I am attempting to do is find the Max of the results of each individual set analysis. Obviously we cannot do nested aggregates, I attempted to store them as variables and do the following on them but again with no joy.

Forklift 1 = 0

Forklift 2 = 10.6

Forklift 3 = 5.4

Max([Forklift 1], [Forklift 2], [Forklift 3]) = 10.6

What would be the best way to tackle this problem?

Thanks!

Labels (1)
• ### Qlik Sense

1 Solution

Accepted Solutions
Highlighted
MVP

You need rangemax function here

rangeMax([Forklift 1], [Forklift 2], [Forklift 3])

2 Replies
Highlighted
MVP

You need rangemax function here

rangeMax([Forklift 1], [Forklift 2], [Forklift 3])

Highlighted
Contributor III

Of course!

Many Thanks