Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi to all,
How to get the top selling product in last Year (and) last Quarter.
Thanks In Advance....
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.
Or you can try something like this:
If(Aggr(Rank(Sum({<Year={2014}, Quarter={'Q4'}>}sales)), product) = 1, product)
Just another approach