Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
c_latham
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
Kushal_Chawda

You need rangemax function here

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

View solution in original post

2 Replies
Kushal_Chawda

You need rangemax function here

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

View solution in original post

c_latham
Contributor III
Contributor III
Author

Of course!

Many Thanks