Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
joybratas1
Contributor II
Contributor II

How to get the Max value from a range of expression

Hi, I want help in the following things-

1. I want to find the max value from a range of values(each value comes from a different expression) and display it in KPI. 

Like -

max(expression1, expression2, expression3, ....) 

Is there a way to write such logic.

 

2. I have buttons for each expression. So when someone selects the button, my above Max(expression1, expression2, ..) should calculate the max value for only those expressions that is selected by  buttons

Labels (2)
1 Reply
henrikalmen
Specialist
Specialist

1. Yes, use RangeMax()

2. It's doable using variables. Something like when a button is pressed, the expression is assigned to a variable and then all buttonvariables that have values are concatenated to fit in your rangemax expression.