Qlik Community

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 
Search instead for 
Did you mean: 
Highlighted
Contributor III
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)
1 Solution

Accepted Solutions
Highlighted
MVP
MVP

You need rangemax function here

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

View solution in original post

2 Replies
Highlighted
MVP
MVP

You need rangemax function here

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

View solution in original post

Highlighted
Contributor III
Contributor III

Of course!

Many Thanks