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

show max value in table

hi

i have a table like below

industryAssetValue
Aa1100
Aa2120
Aa2123
Bb1253
Bb2200

i want table that show industry with sum of value and show the asset with maximum of value like below

IndustryIndustry Valuemax assetasset value
A343a2143
B453b1

253

1 Solution

Accepted Solutions
andrey_krylov
Specialist
Specialist

4 Replies
andrey_krylov
Specialist
Specialist

See attached

omid5ive
Creator II
Creator II
Author

hi

thanks

but i need the asset name too

Capture.PNG

after sum(value) field i need to know the name of asset that have 253 value

andrey_krylov
Specialist
Specialist

Try this

omid5ive
Creator II
Creator II
Author

thanks a lot