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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
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.