topic Re: Percentage Pivot Table in QlikView https://community.qlik.com/t5/QlikView/Percentage-Pivot-Table/m-p/1180145#M382595 <HTML><HEAD></HEAD><BODY><P>Check my response here:</P><P><A href="https://community.qlik.com/thread/233975">Percentage Pivot table</A></P></BODY></HTML> Fri, 23 Sep 2016 16:09:53 GMT sunny_talwar 2016-09-23T16:09:53Z Percentage Pivot Table https://community.qlik.com/t5/QlikView/Percentage-Pivot-Table/m-p/1180144#M382594 <HTML><HEAD></HEAD><BODY><P>Hey, everyone!</P><P></P><P>I'm trying to solve this issue, but it's not working. see:</P><P></P><P>I have a Pivot table, where I have the total produced by machine and by product</P><P>&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="width: 449px;"><TBODY><TR><TH style="color: #ffffff; text-align: center; padding: 2px; background-color: #6690bc;">&nbsp;&nbsp;&nbsp; </TH><TH style="color: #ffffff; text-align: center; padding: 2px; background-color: #6690bc;">Machine A</TH><TH style="color: #ffffff; text-align: center; padding: 2px; background-color: #6690bc;">Machine B</TH><TH style="color: #ffffff; text-align: center; padding: 2px; background-color: #6690bc;">Machine C</TH><TH style="color: #ffffff; text-align: center; padding: 2px; background-color: #6690bc;">Total Per Product</TH></TR><TR><TD class="xl69" height="20" style="color: #575757; text-align: center; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">Product A</TD><TD class="xl70" style="border-left-style: none; color: #575757; text-align: center; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">59</TD><TD class="xl70" style="border-left-style: none; color: #575757; text-align: center; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">47</TD><TD class="xl70" style="border-left-style: none; color: #575757; text-align: center; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">79</TD><TD class="xl71" style="border-left-style: none; color: #575757; text-align: center; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">185</TD></TR><TR><TD class="xl72" height="20" style="border-top-style: none; color: #575757; text-align: center; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">Product B</TD><TD class="xl68" style="border-top-style: none; border-left-style: none; color: #575757; text-align: center; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">27</TD><TD class="xl68" style="border-top-style: none; border-left-style: none; color: #575757; text-align: center; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">52</TD><TD class="xl68" style="border-top-style: none; border-left-style: none; color: #575757; text-align: center; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">22</TD><TD class="xl73" style="border-top-style: none; border-left-style: none; color: #575757; text-align: center; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">101</TD></TR><TR><TD class="xl72" height="20" style="border-top-style: none; color: #575757; text-align: center; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">Product C</TD><TD class="xl68" style="border-top-style: none; border-left-style: none; color: #575757; text-align: center; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">26</TD><TD class="xl68" style="border-top-style: none; border-left-style: none; color: #575757; text-align: center; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">12</TD><TD class="xl68" style="border-top-style: none; border-left-style: none; color: #575757; text-align: center; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">55</TD><TD class="xl73" style="border-top-style: none; border-left-style: none; color: #575757; text-align: center; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">93</TD></TR><TR><TD class="xl74" height="20" style="border-top-style: none; color: #575757; text-align: center; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">Total Per Machine</TD><TD class="xl75" style="border-top-style: none; border-left-style: none; color: #575757; text-align: center; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">112</TD><TD class="xl75" style="border-top-style: none; border-left-style: none; color: #575757; text-align: center; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">111</TD><TD class="xl75" style="border-top-style: none; border-left-style: none; color: #575757; text-align: center; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">156</TD><TD class="xl76" style="border-top-style: none; border-left-style: none; color: #575757; text-align: center; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">379</TD></TR></TBODY></TABLE><P></P><P>I want to show the respective percentage for each one of these (like that below):</P><P>&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="width: 449px;"><TBODY><TR><TH style="color: rgb(255, 255, 255); text-align: center; padding: 2px; background-color: rgb(102, 144, 188);"></TH><TH style="color: rgb(255, 255, 255); text-align: center; padding: 2px; background-color: rgb(102, 144, 188);">Machine A</TH><TH style="color: rgb(255, 255, 255); text-align: center; padding: 2px; background-color: rgb(102, 144, 188);">Machine B</TH><TH style="color: rgb(255, 255, 255); text-align: center; padding: 2px; background-color: rgb(102, 144, 188);">Machine C</TH><TH style="color: rgb(255, 255, 255); text-align: center; padding: 2px; background-color: rgb(102, 144, 188);">Total Per Product</TH></TR><TR><TD class="xl68" height="20" style="color: rgb(87, 87, 87); text-align: center; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">Product A</TD><TD class="xl74" style="border-left-style: none; color: rgb(87, 87, 87); text-align: center; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">32%</TD><TD class="xl74" style="border-left-style: none; color: rgb(87, 87, 87); text-align: center; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">25%</TD><TD class="xl74" style="border-left-style: none; color: rgb(87, 87, 87); text-align: center; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">43%</TD><TD class="xl69" style="border-left-style: none; color: rgb(87, 87, 87); text-align: center; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">1</TD></TR><TR><TD class="xl70" height="20" style="border-top-style: none; color: rgb(87, 87, 87); text-align: center; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">Product B</TD><TD class="xl75" style="border-top-style: none; border-left-style: none; color: rgb(87, 87, 87); text-align: center; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">27%</TD><TD class="xl75" style="border-top-style: none; border-left-style: none; color: rgb(87, 87, 87); text-align: center; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">51%</TD><TD class="xl75" style="border-top-style: none; border-left-style: none; color: rgb(87, 87, 87); text-align: center; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">22%</TD><TD class="xl71" style="border-top-style: none; border-left-style: none; color: rgb(87, 87, 87); text-align: center; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">1</TD></TR><TR><TD class="xl70" height="20" style="border-top-style: none; color: rgb(87, 87, 87); text-align: center; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">Product C</TD><TD class="xl75" style="border-top-style: none; border-left-style: none; color: rgb(87, 87, 87); text-align: center; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">28%</TD><TD class="xl75" style="border-top-style: none; border-left-style: none; color: rgb(87, 87, 87); text-align: center; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">13%</TD><TD class="xl75" style="border-top-style: none; border-left-style: none; color: rgb(87, 87, 87); text-align: center; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">59%</TD><TD class="xl71" style="border-top-style: none; border-left-style: none; color: rgb(87, 87, 87); text-align: center; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">1</TD></TR><TR><TD class="xl72" height="20" style="border-top-style: none; color: rgb(87, 87, 87); text-align: center; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">Total Per Machine</TD><TD class="xl76" style="border-top-style: none; border-left-style: none; color: rgb(87, 87, 87); text-align: center; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">30%</TD><TD class="xl76" style="border-top-style: none; border-left-style: none; color: rgb(87, 87, 87); text-align: center; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">29%</TD><TD class="xl76" style="border-top-style: none; border-left-style: none; color: rgb(87, 87, 87); text-align: center; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">41%</TD><TD class="xl73" style="border-top-style: none; border-left-style: none; color: rgb(87, 87, 87); text-align: center; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">1</TD></TR></TBODY></TABLE><P></P><P></P><P>Can anyone help me, please?</P><P></P><P>Kind regards, Luiz Bisco</P></BODY></HTML> Fri, 23 Sep 2016 12:49:01 GMT https://community.qlik.com/t5/QlikView/Percentage-Pivot-Table/m-p/1180144#M382594 2016-09-23T12:49:01Z Re: Percentage Pivot Table https://community.qlik.com/t5/QlikView/Percentage-Pivot-Table/m-p/1180145#M382595 <HTML><HEAD></HEAD><BODY><P>Check my response here:</P><P><A href="https://community.qlik.com/thread/233975">Percentage Pivot table</A></P></BODY></HTML> Fri, 23 Sep 2016 16:09:53 GMT https://community.qlik.com/t5/QlikView/Percentage-Pivot-Table/m-p/1180145#M382595 sunny_talwar 2016-09-23T16:09:53Z