Announcements
Sept. 27, 10AM ET Do more with Qlik, Insight Advisor – our intelligent AI-assistant in Qlik Sense: Register
cancel
Showing results for
Did you mean:
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

You need rangemax function here

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

2 Replies

You need rangemax function here

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

Contributor III
Author

Of course!

Many Thanks

Tags
Community Browser