topic Re: Product share in QlikView https://community.qlik.com/t5/QlikView/Product-share/m-p/1156968#M377343 <HTML><HEAD></HEAD><BODY><P>Can you share the sample data?</P></BODY></HTML> Tue, 17 May 2016 08:42:01 GMT Kushal_Chawda 2016-05-17T08:42:01Z Product share https://community.qlik.com/t5/QlikView/Product-share/m-p/1156966#M377341 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt;">Hello!</SPAN></P><P><SPAN lang="en" style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN lang="en" style="font-size: 10pt;"><SPAN lang="en">I have this problem.</SPAN></SPAN></P><P><SPAN lang="en" style="font-size: 10pt;"><SPAN lang="en">I want to calculate the proportion of goods. This is <SPAN style="color: #212121; font-family: arial, sans-serif;">small example</SPAN></SPAN></SPAN></P><P><SPAN lang="en" style="font-size: 10pt;"><SPAN lang="en"><BR /></SPAN></SPAN></P><P><SPAN lang="en" style="font-size: 10pt;"><SPAN lang="en"><BR /></SPAN></SPAN></P><P><SPAN lang="en" style="font-size: 10pt;"><SPAN lang="en">Order1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Order2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Order3<BR /></SPAN></SPAN></P><P><SPAN lang="en" style="font-size: 10pt;">product1&nbsp;&nbsp;&nbsp;&nbsp; product1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; product2</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">product2&nbsp;&nbsp;&nbsp;&nbsp; product2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></P><P><SPAN style="line-height: 1.5em; font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; product3</SPAN></P><P><SPAN style="line-height: 1.5em; font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="line-height: 1.5em; font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="line-height: 1.5em; font-size: 13.3333px;">product1 = 1/2 (this order1) + 1/3+ 0</SPAN></P><P><SPAN style="line-height: 1.5em; font-size: 13.3333px;">product2 = 1/2+1/3+1</SPAN></P><P><SPAN style="line-height: 1.5em; font-size: 13.3333px;">product3= 0+1/3+0</SPAN></P><P><SPAN style="line-height: 1.5em; font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="line-height: 1.5em; color: #212121; font-size: 12pt; font-family: arial, sans-serif;">I want to have a table:</SPAN></P><P><SPAN style="line-height: 1.5em; color: #212121; font-size: 12pt; font-family: arial, sans-serif;"><BR /></SPAN></P><P><SPAN style="line-height: 1.5em; color: #212121; font-size: 12pt; font-family: arial, sans-serif;">product1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0,83</SPAN></P><P><SPAN style="line-height: 1.5em; color: #212121; font-size: 12pt; font-family: arial, sans-serif;">product2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,83</SPAN></P><P><SPAN style="line-height: 1.5em; color: #212121; font-size: 12pt; font-family: arial, sans-serif;">product3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0,3</SPAN></P><P><SPAN style="line-height: 1.5em; color: #212121; font-size: 12pt; font-family: arial, sans-serif;"><BR /></SPAN></P><P><SPAN style="line-height: 1.5em; color: #212121; font-size: 12pt; font-family: arial, sans-serif;"><BR /></SPAN></P><P><SPAN style="line-height: 1.5em; color: #212121; font-size: 12pt; font-family: arial, sans-serif;">Thanks!<BR /></SPAN></P></BODY></HTML> Tue, 17 May 2016 08:04:11 GMT https://community.qlik.com/t5/QlikView/Product-share/m-p/1156966#M377341 2016-05-17T08:04:11Z Re: Product share https://community.qlik.com/t5/QlikView/Product-share/m-p/1156967#M377342 <HTML><HEAD></HEAD><BODY><P>May be like this:</P><P></P><P><STRONG>=Sum(Aggr(Count(Product)/Count(TOTAL &lt;OrderNum&gt; Product), OrderNum, Product))</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/124771_Capture.PNG" style="height: 106px; width: 620px;" /><BR /></STRONG></P></BODY></HTML> Tue, 17 May 2016 08:36:48 GMT https://community.qlik.com/t5/QlikView/Product-share/m-p/1156967#M377342 sunny_talwar 2016-05-17T08:36:48Z Re: Product share https://community.qlik.com/t5/QlikView/Product-share/m-p/1156968#M377343 <HTML><HEAD></HEAD><BODY><P>Can you share the sample data?</P></BODY></HTML> Tue, 17 May 2016 08:42:01 GMT https://community.qlik.com/t5/QlikView/Product-share/m-p/1156968#M377343 Kushal_Chawda 2016-05-17T08:42:01Z Re: Product share https://community.qlik.com/t5/QlikView/Product-share/m-p/1156969#M377344 <HTML><HEAD></HEAD><BODY><P class="tw-bilingual-pos vk_dgy" style="padding-bottom: 10px; padding-right: 16px; font-family: arial, sans-serif-light, sans-serif; font-size: 14px; color: #545454 !important;"><SPAN style="font-weight: bold; color: #dd4b39; font-family: arial, helvetica, sans-serif; font-size: 10pt; line-height: 1.5em;">Thank you very much</SPAN></P><DIV class="tw-bilingual-entry tw-bilingual-marked" data-ved="0ahUKEwjnw4_q3eDMAhWCXCwKHQizCK4Q8zYIAygA" style="padding-bottom: 20px; color: #dd4b39 !important;"><P></P></DIV></BODY></HTML> Tue, 17 May 2016 08:53:02 GMT https://community.qlik.com/t5/QlikView/Product-share/m-p/1156969#M377344 2016-05-17T08:53:02Z