Top Selling Product

[#1]

Hi to all,

How to get the top selling product in last Year (and) last Quarter.

Thanks In Advance....

[Gysbert_Wassenaar]

Something like firstsortedvalue({<Year={2014},Quarter={'Q4'}>} product, aggr(-sum(sales),product))

Post a qlikview document with data if you can't figure out how to apply it to your document.

[sinanozdemir]

Or you can try something like this:

If(Aggr(Rank(Sum({<Year={2014}, Quarter={'Q4'}>}sales)), product) = 1, product)

Just another approach