topic Re: Top Customers in QlikView https://community.qlik.com/t5/QlikView/Top-Customers/m-p/1345057#M841528 <HTML><HEAD></HEAD><BODY><P>Could help us providing a sample qvw to work with and explain your expected output against your data sample?</P></BODY></HTML> Mon, 01 May 2017 06:16:17 GMT tresB 2017-05-01T06:16:17Z Top Customers https://community.qlik.com/t5/QlikView/Top-Customers/m-p/1345056#M841527 <HTML><HEAD></HEAD><BODY><P>Hi Community,</P><P></P><P>I need to show customers count in a text object where the sales of customers is more than overall avg sales per customers.</P><P>Also need to show the same customers list in a table with their sales..</P><P></P><P>Please help me with solution</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Top-Customers/m-p/1345056#M841527 dusasuman 2020-11-25T16:16:04Z Re: Top Customers https://community.qlik.com/t5/QlikView/Top-Customers/m-p/1345057#M841528 <HTML><HEAD></HEAD><BODY><P>Could help us providing a sample qvw to work with and explain your expected output against your data sample?</P></BODY></HTML> Mon, 01 May 2017 06:16:17 GMT https://community.qlik.com/t5/QlikView/Top-Customers/m-p/1345057#M841528 tresB 2017-05-01T06:16:17Z Re: Top Customers https://community.qlik.com/t5/QlikView/Top-Customers/m-p/1345058#M841529 <HTML><HEAD></HEAD><BODY><P>Please look at sample data</P></BODY></HTML> Mon, 01 May 2017 06:38:40 GMT https://community.qlik.com/t5/QlikView/Top-Customers/m-p/1345058#M841529 dusasuman 2017-05-01T06:38:40Z Re: Top Customers https://community.qlik.com/t5/QlikView/Top-Customers/m-p/1345059#M841530 <HTML><HEAD></HEAD><BODY><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">=</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">Sum</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">(</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">if</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">(</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">Aggr</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">(</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">Sum</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">(</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">Sales</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">),</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">Cust</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">)&gt;</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">Aggr</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">(</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">Avg</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">(</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">TOTAL</SPAN> <SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">Aggr</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">(</SPAN><SPAN style="color: blue; font-size: 9.0pt; font-family: 'Courier New';">Sum</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">(</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">Sales</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">),</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">Cust</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">)),</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">Cust</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">),1)) </SPAN></P></BODY></HTML> Mon, 01 May 2017 07:04:50 GMT https://community.qlik.com/t5/QlikView/Top-Customers/m-p/1345059#M841530 Anonymous 2017-05-01T07:04:50Z Re: Top Customers https://community.qlik.com/t5/QlikView/Top-Customers/m-p/1345060#M841531 <HTML><HEAD></HEAD><BODY><P>Hi Suman</P><P></P><P>Please create one variable as vAVG = SUM(Sales)/Count(Cust)</P><P></P><P>Text box SET analysis.</P><P>=Count({&lt;Sales={'&gt;=$(=vAVG)'}&gt;}Cust)</P></BODY></HTML> Mon, 01 May 2017 07:23:24 GMT https://community.qlik.com/t5/QlikView/Top-Customers/m-p/1345060#M841531 shiveshsingh 2017-05-01T07:23:24Z Re: Top Customers https://community.qlik.com/t5/QlikView/Top-Customers/m-p/1345061#M841532 <HTML><HEAD></HEAD><BODY><P>PFA</P><P></P><P>Expression in chart :</P><P><EM>=Sum(if(Aggr(Sum(Sales),Cust)&gt;Aggr(Avg(TOTAL Aggr(Sum(Sales),Cust)),Cust),<STRONG>Sales</STRONG>))</EM></P><P><EM><BR /></EM></P><P>Expression in text box:</P><P><EM><BR /></EM></P><P><EM>=<STRONG>Concat</STRONG>(if(Aggr(Sum(Sales),Cust)&gt;Aggr(Avg(TOTAL Aggr(Sum(Sales),Cust)),Cust),<STRONG>Cust</STRONG>), <STRONG>',' </STRONG>)</EM></P></BODY></HTML> Mon, 01 May 2017 07:25:41 GMT https://community.qlik.com/t5/QlikView/Top-Customers/m-p/1345061#M841532 tresB 2017-05-01T07:25:41Z Re: Top Customers https://community.qlik.com/t5/QlikView/Top-Customers/m-p/1345062#M841533 <HTML><HEAD></HEAD><BODY><P>... this solutions is not weighted by customer... we don't know what Suman needs exactly... <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 01 May 2017 07:34:47 GMT https://community.qlik.com/t5/QlikView/Top-Customers/m-p/1345062#M841533 Anonymous 2017-05-01T07:34:47Z Re: Top Customers https://community.qlik.com/t5/QlikView/Top-Customers/m-p/1345063#M841534 <HTML><HEAD></HEAD><BODY><P>Thanks for your reply,</P><P>I have attached the sample file with source data and out put needed. Please find the attachment.. Output sheet is the desired requirement</P></BODY></HTML> Mon, 01 May 2017 07:49:49 GMT https://community.qlik.com/t5/QlikView/Top-Customers/m-p/1345063#M841534 dusasuman 2017-05-01T07:49:49Z Re: Top Customers https://community.qlik.com/t5/QlikView/Top-Customers/m-p/1345064#M841535 <HTML><HEAD></HEAD><BODY><P>did you have a look at the solutions above?!?</P></BODY></HTML> Mon, 01 May 2017 07:51:53 GMT https://community.qlik.com/t5/QlikView/Top-Customers/m-p/1345064#M841535 Anonymous 2017-05-01T07:51:53Z Re: Top Customers https://community.qlik.com/t5/QlikView/Top-Customers/m-p/1345065#M841536 <HTML><HEAD></HEAD><BODY><P>Yes Just looked in to it, Your solution is correct.. Appreciate your help .. Thanks!!</P></BODY></HTML> Mon, 01 May 2017 07:55:40 GMT https://community.qlik.com/t5/QlikView/Top-Customers/m-p/1345065#M841536 dusasuman 2017-05-01T07:55:40Z Re: Top Customers https://community.qlik.com/t5/QlikView/Top-Customers/m-p/1345066#M841537 <HTML><HEAD></HEAD><BODY><P>Thanks Robin for your help. This is not working in qlikssense.. It is showing 1 as output for count of cust meeting the overall avg. Not sure whether qliksense calculation not working</P></BODY></HTML> Mon, 01 May 2017 08:04:31 GMT https://community.qlik.com/t5/QlikView/Top-Customers/m-p/1345066#M841537 dusasuman 2017-05-01T08:04:31Z Re: Top Customers https://community.qlik.com/t5/QlikView/Top-Customers/m-p/1345067#M841538 <HTML><HEAD></HEAD><BODY><P>sorry, I never used QlikSense ... so I can't help here ...</P></BODY></HTML> Mon, 01 May 2017 08:48:36 GMT https://community.qlik.com/t5/QlikView/Top-Customers/m-p/1345067#M841538 Anonymous 2017-05-01T08:48:36Z