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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2011-08-18 06:05 AM

Use rangemax

Hi everyone.

I am working in the margin now, I can calculate margin article one by one but not the total sales, I have two problems:

I take last contract price, it is 9999

SUM ({< AÑOHASTA = {9999}>} PRECIOCOMPRA)

But some articles have more than 1 price. I need to select the highest price. I´m trying wint RANGEMAX in set analysis but the result is null.

Can someone help me?

835 Views
0 Likes
0 Replies