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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
swiftfahad
Contributor III
Contributor III

Maximum value in pivot table

how can I create a pivote table that show the sum(capacity) for the maximum refno.

Memo RefNo Capacity
ABC 45 2
ABC 46 3
ABC 32 14
XYZ 25 2
XYZ 29 17

 

required result is as follow plz suggest an expression i am using 

=max(aggr(sum(Capacity),RefNo)) but it show maximum value of capacity.

Memo RefNo Capacity
ABC 46 3
XYZ 29 17
     
     
     

 

app is also attatched

Labels (1)
1 Solution

Accepted Solutions
tresesco
MVP
MVP

Like this?

tresesco_0-1637824051880.png

FirstSortedValue(Aggr(Sum(Capacity),Memo,RefNo), -RefNo)

View solution in original post

2 Replies
tresesco
MVP
MVP

Like this?

tresesco_0-1637824051880.png

FirstSortedValue(Aggr(Sum(Capacity),Memo,RefNo), -RefNo)

swiftfahad
Contributor III
Contributor III
Author

Bingo.... Thanks champ