Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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)?
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