Comparison measure between 2 Set Analysis

[EmmaKFM]

I have 2 measures with set analysis and I want a 3rd measure giving the lowest of the 2, so along the lines of...

min(Sum(...) , Sum(...))

But qlik is giving an error on nested aggregation. Is there another way to do this? 

Thanks!

[Lucke_Hallbergson]

This is one way to do it that might be suitable (last part, eg put your expressions inside an if statement and pick formula based on comparison between the 2)?

[lennart_mo · Accepted solution]

Hi @EmmaKFM,

I think what your looking for might just be the RangeMin() Function.

RangeMin - Script and chart function | Qlik Cloud Help

Hope this helps!

Best regards

Lennart

[EmmaKFM]

@lennart_mo  That works perfectly!

Thanks both so much for your help

E