topic Re: show max value in table in QlikView

show max value in table

omid5ive — Wed, 10 Oct 2018 06:24:38 GMT

i have a table like below

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

Industry	Industry Value	max asset	asset value
A	343	a2	143
B	453	b1	253

andrey_krylov — Wed, 10 Oct 2018 07:17:50 GMT

See attached

omid5ive — Wed, 10 Oct 2018 07:24:22 GMT

thanks

but i need the asset name too

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

andrey_krylov — Wed, 10 Oct 2018 09:19:27 GMT

Try this

omid5ive — Wed, 10 Oct 2018 11:24:30 GMT

thanks a lot