Max of Multiple Set Analysis values

[c_latham]

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!

[Kushal_Chawda · Accepted solution]

You need rangemax function here

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

[c_latham]

Of course!

Many Thanks