Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
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.