Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
EmmaKFM
New Member
New Member

Comparison measure between 2 Set Analysis

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!

 

Labels (3)
2 Replies
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)?

Lucke_Hallbergson_0-1756994881571.png

 

lennart_mo
Creator
Creator

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