topic Tabla pivotante in QlikView https://community.qlik.com/t5/QlikView/Tabla-pivotante/m-p/1248663#M871488 <HTML><HEAD></HEAD><BODY><P>Buenas tardes.</P><P>Les escribo para que me puedan ayudar con esta herramienta ya que soy nuevo en esto, </P><P>quería realizar una tabla que en excel se veria asi: </P><P></P><P>Imagen 1:</P><TABLE border="1" class="jiveBorder" jive-data-cell="{&quot;color&quot;:&quot;#000000&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;2&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;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">PRODUCTOS</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>ENERO</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>FEBRERO</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>MARZO</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>VENTAS</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>PROMEDIO</STRONG></TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">100</TD><TD style="padding: 2px;">200</TD><TD style="padding: 2px;">50</TD><TD style="padding: 2px;">350</TD><TD style="padding: 2px; background-color: #ffff00;">117</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">200</TD><TD style="padding: 2px;">10</TD><TD style="padding: 2px;">20</TD><TD style="padding: 2px;">230</TD><TD style="padding: 2px; background-color: #ffff00;">77</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">50</TD><TD style="padding: 2px;"><P>0</P></TD><TD style="padding: 2px;">100</TD><TD style="padding: 2px;">150</TD><TD style="background-color: #ffff00;">50</TD></TR><TR><TD style="padding: 2px;">D</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px; background-color: #ffff00;"></TD></TR></TBODY></TABLE><P></P><P></P><P>cuando lo hago en la herramienta Qlikview me aparece asi:</P><P>Imagen 2:</P><TABLE border="1" class="jiveBorder" 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;#FFFF00&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;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" style="border: 1px solid #000000; font-size: 13.3333px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">PRODUCTOS</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>ENERO</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">ENERO</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>FEBRERO</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>FEBRERO</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><P><STRONG>MARZO</STRONG></P></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>MARZO</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>VENTA</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>PROMEDIO</STRONG></TH></TR><TR><TD></TD><TD>VENTA</TD><TD style="background-color: #ffff00;">PROMEDIO</TD><TD>VENTA </TD><TD style="background-color: #ffff00;">PROMEDIO</TD><TD>VENTA</TD><TD style="background-color: #ffff00;">PROMEDIO</TD><TD style="background-color: #ffffff;"></TD><TD style="background-color: #ffffff;"></TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">100</TD><TD style="padding: 2px; background-color: #ffff00;">3</TD><TD style="padding: 2px;">50</TD><TD style="padding: 2px; background-color: #ffff00;">17</TD><TD style="padding: 2px;">200</TD><TD style="background-color: #ffff00;">67</TD><TD style="background-color: #ffffff;">350</TD><TD style="background-color: #ffffff;">117</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">200</TD><TD style="padding: 2px; background-color: #ffff00;"><P>37</P></TD><TD style="padding: 2px;">20</TD><TD style="padding: 2px; background-color: #ffff00;">7</TD><TD style="padding: 2px;">10</TD><TD style="background-color: #ffff00;">4</TD><TD style="background-color: #ffffff;">230</TD><TD style="background-color: #ffffff;">77</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">50</TD><TD style="padding: 2px; background-color: #ffff00;"><P>17</P></TD><TD style="padding: 2px;">100</TD><TD style="padding: 2px; background-color: #ffff00;">150</TD><TD style="padding: 2px;">0</TD><TD style="background-color: #ffff00;">0</TD><TD style="background-color: #ffffff;">150</TD><TD style="background-color: #ffffff;">50</TD></TR></TBODY></TABLE><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Como puedo hacer que la columna promedio me quede como la <STRONG>imagen 1:</STRONG></P><P style="font-size: 13.3333px;"><STRONG><BR /></STRONG></P><P style="font-size: 13.3333px;"><STRONG>Gracias por su ayuda.<BR /></STRONG></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z Tabla pivotante https://community.qlik.com/t5/QlikView/Tabla-pivotante/m-p/1248663#M871488 <HTML><HEAD></HEAD><BODY><P>Buenas tardes.</P><P>Les escribo para que me puedan ayudar con esta herramienta ya que soy nuevo en esto, </P><P>quería realizar una tabla que en excel se veria asi: </P><P></P><P>Imagen 1:</P><TABLE border="1" class="jiveBorder" jive-data-cell="{&quot;color&quot;:&quot;#000000&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;2&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;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">PRODUCTOS</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>ENERO</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>FEBRERO</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>MARZO</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>VENTAS</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>PROMEDIO</STRONG></TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">100</TD><TD style="padding: 2px;">200</TD><TD style="padding: 2px;">50</TD><TD style="padding: 2px;">350</TD><TD style="padding: 2px; background-color: #ffff00;">117</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">200</TD><TD style="padding: 2px;">10</TD><TD style="padding: 2px;">20</TD><TD style="padding: 2px;">230</TD><TD style="padding: 2px; background-color: #ffff00;">77</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">50</TD><TD style="padding: 2px;"><P>0</P></TD><TD style="padding: 2px;">100</TD><TD style="padding: 2px;">150</TD><TD style="background-color: #ffff00;">50</TD></TR><TR><TD style="padding: 2px;">D</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px; background-color: #ffff00;"></TD></TR></TBODY></TABLE><P></P><P></P><P>cuando lo hago en la herramienta Qlikview me aparece asi:</P><P>Imagen 2:</P><TABLE border="1" class="jiveBorder" 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;#FFFF00&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;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" style="border: 1px solid #000000; font-size: 13.3333px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">PRODUCTOS</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>ENERO</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">ENERO</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>FEBRERO</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>FEBRERO</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><P><STRONG>MARZO</STRONG></P></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>MARZO</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>VENTA</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>PROMEDIO</STRONG></TH></TR><TR><TD></TD><TD>VENTA</TD><TD style="background-color: #ffff00;">PROMEDIO</TD><TD>VENTA </TD><TD style="background-color: #ffff00;">PROMEDIO</TD><TD>VENTA</TD><TD style="background-color: #ffff00;">PROMEDIO</TD><TD style="background-color: #ffffff;"></TD><TD style="background-color: #ffffff;"></TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">100</TD><TD style="padding: 2px; background-color: #ffff00;">3</TD><TD style="padding: 2px;">50</TD><TD style="padding: 2px; background-color: #ffff00;">17</TD><TD style="padding: 2px;">200</TD><TD style="background-color: #ffff00;">67</TD><TD style="background-color: #ffffff;">350</TD><TD style="background-color: #ffffff;">117</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">200</TD><TD style="padding: 2px; background-color: #ffff00;"><P>37</P></TD><TD style="padding: 2px;">20</TD><TD style="padding: 2px; background-color: #ffff00;">7</TD><TD style="padding: 2px;">10</TD><TD style="background-color: #ffff00;">4</TD><TD style="background-color: #ffffff;">230</TD><TD style="background-color: #ffffff;">77</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">50</TD><TD style="padding: 2px; background-color: #ffff00;"><P>17</P></TD><TD style="padding: 2px;">100</TD><TD style="padding: 2px; background-color: #ffff00;">150</TD><TD style="padding: 2px;">0</TD><TD style="background-color: #ffff00;">0</TD><TD style="background-color: #ffffff;">150</TD><TD style="background-color: #ffffff;">50</TD></TR></TBODY></TABLE><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Como puedo hacer que la columna promedio me quede como la <STRONG>imagen 1:</STRONG></P><P style="font-size: 13.3333px;"><STRONG><BR /></STRONG></P><P style="font-size: 13.3333px;"><STRONG>Gracias por su ayuda.<BR /></STRONG></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Tabla-pivotante/m-p/1248663#M871488 2020-11-25T16:16:04Z