Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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?

0 Replies