Discussion Board for collaboration related to QlikView App Development.
i have several data like this
Name of product amount
now here top 2 products name in textbox like this
product2 , product 6
means i want to get top selling products name in textbox
how i do this
kindly check updated attachements in question i use your solution but this shows an error
nested aggregation is not allowed..
and secondly i use this but this shows only amount 1500 ... products is not display
='Top Salesperson: ' & firstsortedvalue( products, -Aggr(sum(amount),products)) & ', Sales: ' & num(max(Aggr(sum(amount),products)))