find order of Max Amount - Qlik Community

vipin_mishra479 · ‎2013-05-14

hi all ,

I have using this expression to find the max amount

max(aggr(sum({<model = {'SB42'},country = {'India'}>}Amount),Product_Desc,Product_Order)

how i find the max amount Product_Order

kumarnatarajan · ‎2013-05-14

Hi,

Try this one

=SUM({$<Product_Order={"=Rank(aggr(sum({$<model = {'SB42'},country = {'India'}>}Amount),Product_Desc,Product_Order))=1"}>}Amount)

Report Inappropriate Content · ‎2013-05-14

try this

max(aggr(sum({<Product_Order=p({1<model = {'SB42'},country = {'India'}>}Product_Order)>}Amount),Product_Desc,Product_Order)

vipin_mishra479 · ‎2013-05-14

hi Natrajan,

this is my data formate

i want to bold data on my chart

kumarnatarajan · ‎2013-05-14

Hi,

You already post this Discussions. See the below link

vipin_mishra479 · ‎2013-05-14

but when i try the given expression in my orignal application is not work thats why i asked aggain what i do in my original exp.

vipin_mishra479 · ‎2013-05-14

hi viswaranjan,

actually your expression show me a max amount but i want max amount order

er_mohit · ‎2013-05-14

TRY

First sorted value in expression

Firstsortedvalue(AmountOrder,-Amount)

or try this concept in script

hope it helps

vipin_mishra479 · ‎2013-05-14

thanks for reply mohit

but when i try first shorted value in my script then it show some value is blank

because 2 different order value are same so system is confused that which one is max

er_mohit · ‎2013-05-14

sum({$<Product_Order=p({$<model = {'SB42'},country = {'India'}>}Product_Order),Amount={">=$(=max(Amount))"}>}Product_Order)