topic Basic in QlikView https://community.qlik.com/t5/QlikView/Basic/m-p/735451#M1064135 <HTML><HEAD></HEAD><BODY><P>i have customer vs invoice(s) data sheet in excel</P><P>first I have to count no of invoices for each customer and</P><P>i I want to see customer who have max invoice in text object</P></BODY></HTML> Thu, 18 Sep 2014 22:52:48 GMT 2014-09-18T22:52:48Z Basic https://community.qlik.com/t5/QlikView/Basic/m-p/735451#M1064135 <HTML><HEAD></HEAD><BODY><P>i have customer vs invoice(s) data sheet in excel</P><P>first I have to count no of invoices for each customer and</P><P>i I want to see customer who have max invoice in text object</P></BODY></HTML> Thu, 18 Sep 2014 22:52:48 GMT https://community.qlik.com/t5/QlikView/Basic/m-p/735451#M1064135 2014-09-18T22:52:48Z Re: Basic https://community.qlik.com/t5/QlikView/Basic/m-p/735452#M1064136 <HTML><HEAD></HEAD><BODY><P>please post sample data with expected result</P></BODY></HTML> Thu, 18 Sep 2014 23:02:06 GMT https://community.qlik.com/t5/QlikView/Basic/m-p/735452#M1064136 MarcoWedel 2014-09-18T23:02:06Z Re: Basic https://community.qlik.com/t5/QlikView/Basic/m-p/735453#M1064137 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try like this</P><P></P><P>=FirstSortedValue(customer, -Aggr(Count(Invoices), customer))</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Fri, 19 Sep 2014 03:47:31 GMT https://community.qlik.com/t5/QlikView/Basic/m-p/735453#M1064137 jagan 2014-09-19T03:47:31Z Re: Basic https://community.qlik.com/t5/QlikView/Basic/m-p/735454#M1064138 <HTML><HEAD></HEAD><BODY><P>=max(aggr(count(invoice),customer))</P><P></P><P>This will do the trick..</P><P>Sundar</P></BODY></HTML> Fri, 19 Sep 2014 03:55:56 GMT https://community.qlik.com/t5/QlikView/Basic/m-p/735454#M1064138 sundarakumar 2014-09-19T03:55:56Z Re: Basic https://community.qlik.com/t5/QlikView/Basic/m-p/735455#M1064139 <HTML><HEAD></HEAD><BODY><P>Number of Invoices for each customer</P><P>COUNT(DISTINCT [Invoice NO])</P><P></P><P>Customer having Maximum Invoices in Text Box...</P><P>=FirstSortedValue(Customer, -Aggr(Count(DISTINCT [Invoice NO]),Customer))</P></BODY></HTML> Fri, 19 Sep 2014 08:31:15 GMT https://community.qlik.com/t5/QlikView/Basic/m-p/735455#M1064139 MK_QSL 2014-09-19T08:31:15Z Re: Basic https://community.qlik.com/t5/QlikView/Basic/m-p/735456#M1064140 <HTML><HEAD></HEAD><BODY><P>thanks to all who helped me its solved</P></BODY></HTML> Fri, 19 Sep 2014 16:04:25 GMT https://community.qlik.com/t5/QlikView/Basic/m-p/735456#M1064140 2014-09-19T16:04:25Z Re: Basic https://community.qlik.com/t5/QlikView/Basic/m-p/735457#M1064141 <HTML><HEAD></HEAD><BODY><P>Please close the thread by marking appropriate correct and helpful answers.<IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P>-Sundar</P></BODY></HTML> Fri, 19 Sep 2014 20:49:51 GMT https://community.qlik.com/t5/QlikView/Basic/m-p/735457#M1064141 sundarakumar 2014-09-19T20:49:51Z