topic Re: Customers With out Sale in QlikView https://community.qlik.com/t5/QlikView/Customers-With-out-Sale/m-p/62173#M10360 <HTML><HEAD></HEAD><BODY><P>Another option</P><P></P><P><STRONG>Sum(sales_total) + Sum({1&lt;sman_code = p(sman_code)&gt;} 0)</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/201680_Capture.PNG" style="height: auto;" /><BR /></STRONG></P></BODY></HTML> Mon, 07 May 2018 11:24:03 GMT sunny_talwar 2018-05-07T11:24:03Z Customers With out Sale https://community.qlik.com/t5/QlikView/Customers-With-out-Sale/m-p/62171#M10358 <HTML><HEAD></HEAD><BODY><P>Dear Folks,</P><P></P><P>I'm having data for&nbsp; Sman's ,customer wise sale who is having 7 customers for Sman_code 001 and 4 for Sman 013</P><P></P><P>Now my requirement is to display the customer wise sale for Sman's&nbsp; along with no sale customers for that months</P><P></P><P>For reference purpose in the month of August sale happened with 3 customers as displayed but Sman 013 has 4 customers where no sale happened with one customer as shown below in&nbsp; table1 when filtered Month wise</P><P></P><P>Now I want to Display the 4th customer as well with sale as '0' to analyse Sman wise customer performasnce like that based on the month selection i want to display all the customers with both sale and no sale</P><P></P><P><STRONG>Table1.</STRONG></P><P><STRONG><BR /></STRONG></P><TABLE border="1" class="jiveBorder" height="124" style="border: 1px solid #000000; width: 115px; height: 115px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Month</STRONG></TH></TR><TR><TD style="padding: 2px;"><SPAN style="color: #00ff00;">Aug</SPAN></TD></TR><TR><TD style="padding: 2px;">Sep</TD></TR><TR><TD style="padding: 2px;">Oct</TD></TR><TR><TD style="padding: 2px;">Nov</TD></TR><TR><TD style="padding: 2px;">Dec</TD></TR></TBODY></TABLE><TABLE border="1" class="jiveBorder" height="74" style="border: 1px solid #000000; width: 124px; height: 69px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Sman</STRONG></TH></TR><TR><TD style="padding: 2px;">001</TD></TR><TR><TD style="padding: 2px;"><SPAN style="color: #00ff00;">013<BR /></SPAN></TD></TR></TBODY></TABLE><P></P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Sman</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Customer</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>sale</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"></TH></TR><TR><TD style="padding: 2px;">013</TD><TD style="padding: 2px;">DA220</TD><TD style="padding: 2px;">20103</TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">013</TD><TD style="padding: 2px;">DAA02</TD><TD style="padding: 2px;">10789</TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">013</TD><TD style="padding: 2px;">DAA20</TD><TD style="padding: 2px;">5916</TD></TR></TBODY></TABLE><P></P><P></P><P></P><P><STRONG style="color: #00ff00;"><EM>Expected Output </EM></STRONG></P><P><STRONG>Table 2:</STRONG></P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Sman</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Customer</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>sale</STRONG></TH></TR><TR><TD style="padding: 2px;">013</TD><TD style="padding: 2px;">DA220</TD><TD style="padding: 2px;">20103</TD></TR><TR><TD style="padding: 2px;">013</TD><TD style="padding: 2px;">DAA02</TD><TD style="padding: 2px;">10789</TD></TR><TR><TD style="padding: 2px;">013</TD><TD style="padding: 2px;">DAA20</TD><TD style="padding: 2px;">5916</TD></TR><TR><TD style="padding: 2px;">013</TD><TD style="padding: 2px;">DAB20</TD><TD style="padding: 2px;">0</TD></TR></TBODY></TABLE><P>&nbsp; </P><P><A href="https://community.qlik.com/qlik-users/171708">stalwar1</A>‌</P><P><A href="https://community.qlik.com/qlik-users/26418">tresesco</A>‌</P><P><A href="https://community.qlik.com/qlik-users/178253">tamilarasu</A>‌</P><P><A href="https://community.qlik.com/qlik-users/120618">mrkachhiaimp</A>‌</P></BODY></HTML> Mon, 07 May 2018 10:35:55 GMT https://community.qlik.com/t5/QlikView/Customers-With-out-Sale/m-p/62171#M10358 kakani87 2018-05-07T10:35:55Z Re: Customers With out Sale https://community.qlik.com/t5/QlikView/Customers-With-out-Sale/m-p/62172#M10359 <HTML><HEAD></HEAD><BODY><P>Try:</P><P></P><P>sum(sales_total)*<STRONG>avg({&lt;CalendarMonthAndYear&gt;}1)</STRONG></P><P></P><P><IMG __jive_id="201675" alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/201675_Capture.JPG" style="height: auto;" /></P></BODY></HTML> Mon, 07 May 2018 10:51:06 GMT https://community.qlik.com/t5/QlikView/Customers-With-out-Sale/m-p/62172#M10359 tresB 2018-05-07T10:51:06Z Re: Customers With out Sale https://community.qlik.com/t5/QlikView/Customers-With-out-Sale/m-p/62173#M10360 <HTML><HEAD></HEAD><BODY><P>Another option</P><P></P><P><STRONG>Sum(sales_total) + Sum({1&lt;sman_code = p(sman_code)&gt;} 0)</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/201680_Capture.PNG" style="height: auto;" /><BR /></STRONG></P></BODY></HTML> Mon, 07 May 2018 11:24:03 GMT https://community.qlik.com/t5/QlikView/Customers-With-out-Sale/m-p/62173#M10360 sunny_talwar 2018-05-07T11:24:03Z