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: 
krmvacar
Creator II
Creator II

Firs stored value group by

Hi , 

I have the following data. What I want to do here is to get the highest customer number from the ones that contain the customer ID in (1,2,3) and collect their price.

my expression;

sum(aggr(FirstSortedValue([TOTAL_PRICE],-Aggr(sum({<[OFFER_ID]={'01','02','03'}>}[OLPSALHEAD.DOCNUM]),[TOTAL_PRICE],))
,[Customer_Name]))

its not working 😞

Help please

 

EXAMPLE_SENSE.PNG

4 Replies
agigliotti
Partner - Champion
Partner - Champion

Hi @krmvacar ,

It's not clear to me, what is your actual result and the expected one?

krmvacar
Creator II
Creator II
Author

Hi @agigliotti  ,

get the price of the person with the highest offer  number

AshutoshBhumkar
Partner - Specialist
Partner - Specialist

Hi, Is the expected output 149000 ?

As Customer JOHN Contains Offer id 1,2,3 and max offer number 1347.

krmvacar
Creator II
Creator II
Author

Hi @AshutoshBhumkar ,

Yes for JOHN 149000 and max offer number 1347 and for ABC max offer number 1455.

thank you so much