Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculating max and min value from a calculated expression

Hi

So happy to have this community which has already helped me with problems. No I have a new one. Will try to explain this in an example:

I have information from a company which includes articles, revenue and quantity. From this I have calculated the price of each article in a new expression and I have put it in a new column. Now I would like to calculate the max and min value of the price. How do I do this?

Thanx - really appreciating the help.

3 Replies
Not applicable
Author

hi,

you can create max(price) and min(price) as new columns

thanks

Not applicable
Author

Or without creating a new column just do Min (Revenue/quantity) and Max (Revenue/quantiy)

Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

I'm guessing that you need to find the min and max of the calculated price by article... In order to do that, you need to use Advanced Aggregation function aggr(). Something like the following:

Min( AGGR( sum(Revenue)/sum(Quantity), Article) )

Function AGGR() will aggregate your Expression by Article, and then the resulting array of numbers can be aggregated again with Min or Max.