Skip to main content
Announcements
YOUR OPINION MATTERS! Please take the Qlik Experience survey you received via email. Survey ends June 14.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Aggregating measures

Hi Community,

I'm trying to build the following column in the below table in QV. I need the max Sales person sales amount for the each row.

   

Sales_PersonDatesum(Sales)Max SP Sales (Requirement)
Joy1/1/2016$50.00150
Joy1/2/2016$150.00150
Joy1/3/2016$100.00100
Tim1/1/2016$30.0045
Tim1/2/2016$45.0045

I was trying to use the following expression, but to no avail. 

max(total <Sales_Person> aggr(sum(Sales), Sales_Person))

Please provide your guidance. Thanks V.

1 Solution

Accepted Solutions
sunny_talwar

Try this:

Max(total <Sales_Person> aggr(sum(Sales), Sales_Person, Date))


Capture.PNG

View solution in original post

2 Replies
sunny_talwar

Try this:

Max(total <Sales_Person> aggr(sum(Sales), Sales_Person, Date))


Capture.PNG

Not applicable
Author

Thanks Sunny. Much appreciated