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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

min and max values not coming for an expression.request help please??

Hi all,

Please help me out with below issue.

I have an expression

sum({<cp>}(Nominal_Quantity*asoff_payoff)) which results with series of negative and positive values.

how do I get the min and max of the resultant  values

I tried min(sum({<cp>}(Nominal_Quantity*asoff_payoff)))

(Min(aggr(sum({<callput_type>}(Nominal_Quantity1*asoff_payoff)), market)))  but both of this doesn't work

something like a text box where one could give min value and the other the max value.

I have attached the file for reference.please help!!!!

2 Replies
Not applicable
Author

Can't you try RangeMin(), RangeMax()?

Not applicable
Author

thanks for your help

hi I tried total, and it worked.