topic Top Selling Product in QlikView https://community.qlik.com/t5/QlikView/Top-Selling-Product/m-p/869445#M995146 <HTML><HEAD></HEAD><BODY><P>Hi to all,</P><P></P><P>How to get the top selling product in last Year (and) last Quarter.</P><P></P><P>Thanks In Advance....</P></BODY></HTML> Thu, 02 Jul 2015 07:19:14 GMT 2015-07-02T07:19:14Z Top Selling Product https://community.qlik.com/t5/QlikView/Top-Selling-Product/m-p/869445#M995146 <HTML><HEAD></HEAD><BODY><P>Hi to all,</P><P></P><P>How to get the top selling product in last Year (and) last Quarter.</P><P></P><P>Thanks In Advance....</P></BODY></HTML> Thu, 02 Jul 2015 07:19:14 GMT https://community.qlik.com/t5/QlikView/Top-Selling-Product/m-p/869445#M995146 2015-07-02T07:19:14Z Re: Top Selling Product https://community.qlik.com/t5/QlikView/Top-Selling-Product/m-p/869446#M995147 <HTML><HEAD></HEAD><BODY><P>Something like firstsortedvalue({&lt;Year={2014},Quarter={'Q4'}&gt;} product, aggr(-sum(sales),product))</P><P>Post a qlikview document with data if you can't figure out how to apply it to your document.</P></BODY></HTML> Thu, 02 Jul 2015 15:16:50 GMT https://community.qlik.com/t5/QlikView/Top-Selling-Product/m-p/869446#M995147 Gysbert_Wassenaar 2015-07-02T15:16:50Z Re: Top Selling Product https://community.qlik.com/t5/QlikView/Top-Selling-Product/m-p/869447#M995148 <HTML><HEAD></HEAD><BODY><P>Or you can try something like this:</P><P></P><P>If(Aggr(Rank(Sum({&lt;Year={2014}, Quarter={'Q4'}&gt;}sales)), product) = 1, product) </P><P>Just another approach</P></BODY></HTML> Mon, 06 Jul 2015 14:40:39 GMT https://community.qlik.com/t5/QlikView/Top-Selling-Product/m-p/869447#M995148 sinanozdemir 2015-07-06T14:40:39Z