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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

MIN( [SET_Expression] )

Hello,

I'm looking for a way to code a min function on several aggragations. I want to use this in a graph to set min value on the axis.

The idea would be to get the min( { Sum(ThisYear), Sum(LastYear), Sum(Profitplan)) - 10000 (for example).

Can this be coded ?

1 Solution

Accepted Solutions
johnw
Champion III
Champion III

rangemin(sum(ThisYear),sum(LastYear),sum(Profitplan)) - 10000

View solution in original post

1 Reply
johnw
Champion III
Champion III

rangemin(sum(ThisYear),sum(LastYear),sum(Profitplan)) - 10000