topic Difficult pivot table in QlikView https://community.qlik.com/t5/QlikView/Difficult-pivot-table/m-p/340838#M576644 <HTML><HEAD></HEAD><BODY><P>Tryin to create pivot table:</P><P></P><P></P><TABLE border="1" cellpadding="1" cellspacing="1" class="jiveBorder" height="263" style="height: 159px; width: 865px; border-width: 1px; border-color: #7f7e81; border-style: solid;"><TBODY><TR><TD class="xl64" height="21" width="101"><BR /></TD><TD class="xl64" width="67"><BR /></TD><TD class="xl119" colspan="2" style="border-right-width: 1pt; border-right-style: solid; border-right-color: black;" width="373"><STRONG>Block1</STRONG></TD><TD class="xl122" colspan="2" style="border-left-style: none; border-left-width: initial; border-left-color: initial;" width="428">WEEK45</TD><TD class="xl122" colspan="2" width="428">WEEK 46</TD><TD class="xl122" colspan="2" width="428">WEEK 47++</TD><TD class="xl124" colspan="2" style="border-right-width: 1pt; border-right-style: solid; border-right-color: black;" width="124">Difference</TD><TD class="xl116" colspan="2" style="border-left-style: none; border-left-width: initial; border-left-color: initial; border-right-width: 1pt; border-right-style: solid; border-right-color: black;" width="172"><STRONG>Block2</STRONG></TD></TR><TR><TD class="xl65" height="66" width="101">Dimension1</TD><TD class="xl66" style="border-left-style: none; border-left-width: initial; border-left-color: initial;" width="67">Dimension2</TD><TD class="xl67" style="border-top-style: none; border-top-width: initial; border-top-color: initial; border-left-style: none; border-left-width: initial; border-left-color: initial;" width="44">Expr1</TD><TD class="xl71" style="border-top-style: none; border-top-width: initial; border-top-color: initial; border-left-style: none; border-left-width: initial; border-left-color: initial;" width="42">Expr2</TD><TD class="xl72" style="border-top-style: none; border-top-width: initial; border-top-color: initial; border-left-style: none; border-left-width: initial; border-left-color: initial;" width="47">Expr3</TD><TD class="xl75" style="border-top-style: none; border-top-width: initial; border-top-color: initial; border-left-style: none; border-left-width: initial; border-left-color: initial;" width="35">Expr4</TD><TD class="xl72" style="border-top-style: none; border-top-width: initial; border-top-color: initial;" width="47">Expr3</TD><TD class="xl75" style="border-top-style: none; border-top-width: initial; border-top-color: initial; border-left-style: none; border-left-width: initial; border-left-color: initial;" width="35">Expr4</TD><TD class="xl72" style="border-top-style: none; border-top-width: initial; border-top-color: initial;" width="47">Expr3</TD><TD class="xl76" style="border-top-style: none; border-top-width: initial; border-top-color: initial; border-left-style: none; border-left-width: initial; border-left-color: initial;" width="35">Expr4</TD><TD class="xl77" style="border-top-style: none; border-top-width: initial; border-top-color: initial;" width="62">Expr5</TD><TD class="xl78" style="border-top-style: none; border-top-width: initial; border-top-color: initial;" width="62">Expr6</TD><TD class="xl79" style="border-top-style: none; border-top-width: initial; border-top-color: initial; border-left-style: none; border-left-width: initial; border-left-color: initial;" width="62">Expr7</TD><TD class="xl81" style="border-top-style: none; border-top-width: initial; border-top-color: initial; border-left-style: none; border-left-width: initial; border-left-color: initial;" width="45">Expr8</TD></TR><TR><TD class="xl83" height="15">a</TD><TD class="xl85" style="border-left-style: none; border-left-width: initial; border-left-color: initial;">TOTAL</TD><TD align="right" class="xl86" style="border-left-style: none; border-left-width: initial; border-left-color: initial;"><BR /></TD><TD align="right" class="xl87"><BR /></TD><TD align="right" class="xl86"><BR /></TD><TD align="right" class="xl87"><BR /></TD><TD align="right" class="xl86"><BR /></TD><TD align="right" class="xl87"><BR /></TD><TD align="right" class="xl86"><BR /></TD><TD align="right" class="xl89"><BR /></TD><TD align="right" class="xl90" style="border-top-style: none; border-top-width: initial; border-top-color: initial;"><BR /></TD><TD align="right" class="xl91" style="border-top-style: none; border-top-width: initial; border-top-color: initial;"><BR /></TD><TD align="right" class="xl86"><BR /></TD><TD align="right" class="xl92" style="border-left-style: none; border-left-width: initial; border-left-color: initial;"><BR /></TD></TR><TR><TD class="xl83" height="15"></TD><TD class="xl85" style="border-left-style: none; border-left-width: initial; border-left-color: initial;">q</TD><TD align="right" class="xl86" style="border-left-style: none; border-left-width: initial; border-left-color: initial;"><BR /></TD><TD align="right" class="xl87"><BR /></TD><TD align="right" class="xl86"><BR /></TD><TD align="right" class="xl87"></TD><TD align="right" class="xl86"><BR /></TD><TD align="right" class="xl87"><BR /></TD><TD align="right" class="xl86"><BR /></TD><TD align="right" class="xl89"><BR /></TD><TD align="right" class="xl94"><BR /></TD><TD align="right" class="xl95"><BR /></TD><TD align="right" class="xl86"><BR /></TD><TD align="right" class="xl92" style="border-left-style: none; border-left-width: initial; border-left-color: initial;"><BR /></TD></TR><TR><TD class="xl83" height="15"></TD><TD class="xl85" style="border-left-style: none; border-left-width: initial; border-left-color: initial;">qw</TD><TD align="right" class="xl86" style="border-left-style: none; border-left-width: initial; border-left-color: initial;"><BR /></TD><TD align="right" class="xl87"><BR /></TD><TD align="right" class="xl86"><BR /></TD><TD align="right" class="xl87"><BR /></TD><TD align="right" class="xl86"><BR /></TD><TD align="right" class="xl87"><BR /></TD><TD align="right" class="xl86"><BR /></TD><TD align="right" class="xl89"><BR /></TD><TD align="right" class="xl94"><BR /></TD><TD align="right" class="xl95"><BR /></TD><TD align="right" class="xl86"><BR /></TD><TD align="right" class="xl92" style="border-left-style: none; border-left-width: initial; border-left-color: initial;"><BR /></TD></TR><TR><TD class="xl83" height="15"></TD><TD class="xl85" style="border-left-style: none; border-left-width: initial; border-left-color: initial;">qwe</TD><TD align="right" class="xl86" style="border-left-style: none; border-left-width: initial; border-left-color: initial;"><BR /></TD><TD align="right" class="xl87"><BR /></TD><TD align="right" class="xl86"><BR /></TD><TD align="right" class="xl87"></TD><TD align="right" class="xl86"><BR /></TD><TD align="right" class="xl87"><BR /></TD><TD align="right" class="xl86"><BR /></TD><TD align="right" class="xl89"><BR /></TD><TD align="right" class="xl94"><BR /></TD><TD align="right" class="xl95"><BR /></TD><TD align="right" class="xl86"><BR /></TD><TD align="right" class="xl92" style="border-left-style: none; border-left-width: initial; border-left-color: initial;"><BR /></TD></TR><TR><TD class="xl97" height="15">as</TD><TD class="xl98" style="border-left-style: none; border-left-width: initial; border-left-color: initial;">TOTAL</TD><TD align="right" class="xl96" style="border-left-style: none; border-left-width: initial; border-left-color: initial;"><BR /></TD><TD align="right" class="xl99"></TD><TD align="right" class="xl96"></TD><TD align="right" class="xl99"></TD><TD align="right" class="xl96"><BR /></TD><TD align="right" class="xl99"><BR /></TD><TD align="right" class="xl96"><BR /></TD><TD align="right" class="xl101"><BR /></TD><TD align="right" class="xl102"><BR /></TD><TD align="right" class="xl103"><BR /></TD><TD align="right" class="xl96"><BR /></TD><TD align="right" class="xl104" style="border-left-style: none; border-left-width: initial; border-left-color: initial;"><BR /></TD></TR><TR><TD class="xl83" height="15"></TD><TD class="xl85" style="border-left-style: none; border-left-width: initial; border-left-color: initial;">q</TD><TD align="right" class="xl86" style="border-left-style: none; border-left-width: initial; border-left-color: initial;"><BR /></TD><TD align="right" class="xl87"></TD><TD align="right" class="xl86"><BR /></TD><TD align="right" class="xl87"></TD><TD align="right" class="xl86"><BR /></TD><TD align="right" class="xl87"><BR /></TD><TD align="right" class="xl86"><BR /></TD><TD align="right" class="xl89"><BR /></TD><TD align="right" class="xl94"><BR /></TD><TD align="right" class="xl95"><BR /></TD><TD align="right" class="xl86"><BR /></TD><TD align="right" class="xl92" style="border-left-style: none; border-left-width: initial; border-left-color: initial;"><BR /></TD></TR><TR><TD class="xl83" height="15"></TD><TD class="xl85" style="border-left-style: none; border-left-width: initial; border-left-color: initial;">qw</TD><TD align="right" class="xl86" style="border-left-style: none; border-left-width: initial; border-left-color: initial;"><BR /></TD><TD align="right" class="xl87"></TD><TD align="right" class="xl86"><BR /></TD><TD align="right" class="xl87"></TD><TD align="right" class="xl86"><BR /></TD><TD align="right" class="xl87"><BR /></TD><TD align="right" class="xl86"><BR /></TD><TD align="right" class="xl89"><BR /></TD><TD align="right" class="xl94"><BR /></TD><TD align="right" class="xl95"><BR /></TD><TD align="right" class="xl86"><BR /></TD><TD align="right" class="xl92" style="border-left-style: none; border-left-width: initial; border-left-color: initial;"><BR /></TD></TR><TR><TD class="xl83" height="15"></TD><TD class="xl85" style="border-left-style: none; border-left-width: initial; border-left-color: initial;">qwe</TD><TD align="right" class="xl86" style="border-left-style: none; border-left-width: initial; border-left-color: initial;"><BR /></TD><TD align="right" class="xl87"></TD><TD align="right" class="xl86"><BR /></TD><TD align="right" class="xl87"></TD><TD align="right" class="xl86"><BR /></TD><TD align="right" class="xl87"><BR /></TD><TD align="right" class="xl86"><BR /></TD><TD align="right" class="xl89"><BR /></TD><TD align="right" class="xl94"><BR /></TD><TD align="right" class="xl95"><BR /></TD><TD align="right" class="xl86"><BR /></TD><TD align="right" class="xl92" style="border-left-style: none; border-left-width: initial; border-left-color: initial;"><BR /></TD></TR><TR><TD class="xl106" height="15">TOTAL</TD><TD class="xl107" style="border-left-style: none; border-left-width: initial; border-left-color: initial;"></TD><TD align="right" class="xl105" style="border-left-style: none; border-left-width: initial; border-left-color: initial;"><BR /></TD><TD align="right" class="xl108"></TD><TD align="right" class="xl105"></TD><TD align="right" class="xl108"></TD><TD align="right" class="xl105"><BR /></TD><TD align="right" class="xl108"><BR /></TD><TD align="right" class="xl105"><BR /></TD><TD align="right" class="xl110"><BR /></TD><TD align="right" class="xl111"><BR /></TD><TD align="right" class="xl112"><BR /></TD><TD align="right" class="xl105"><BR /></TD><TD align="right" class="xl113" style="border-left-style: none; border-left-width: initial; border-left-color: initial;"><BR /></TD></TR></TBODY></TABLE><P></P><P></P><P>Question: How to combine blocks, what groups of dimensions and groups of expression i need?</P></BODY></HTML> Fri, 06 Apr 2012 09:26:42 GMT 2012-04-06T09:26:42Z Difficult pivot table https://community.qlik.com/t5/QlikView/Difficult-pivot-table/m-p/340838#M576644 <HTML><HEAD></HEAD><BODY><P>Tryin to create pivot table:</P><P></P><P></P><TABLE border="1" cellpadding="1" cellspacing="1" class="jiveBorder" height="263" style="height: 159px; width: 865px; border-width: 1px; border-color: #7f7e81; border-style: solid;"><TBODY><TR><TD class="xl64" height="21" width="101"><BR /></TD><TD class="xl64" width="67"><BR /></TD><TD class="xl119" colspan="2" style="border-right-width: 1pt; border-right-style: solid; border-right-color: black;" width="373"><STRONG>Block1</STRONG></TD><TD class="xl122" colspan="2" style="border-left-style: none; border-left-width: initial; border-left-color: initial;" width="428">WEEK45</TD><TD class="xl122" colspan="2" width="428">WEEK 46</TD><TD class="xl122" colspan="2" width="428">WEEK 47++</TD><TD class="xl124" colspan="2" style="border-right-width: 1pt; border-right-style: solid; border-right-color: black;" width="124">Difference</TD><TD class="xl116" colspan="2" style="border-left-style: none; border-left-width: initial; border-left-color: initial; border-right-width: 1pt; border-right-style: solid; border-right-color: black;" width="172"><STRONG>Block2</STRONG></TD></TR><TR><TD class="xl65" height="66" width="101">Dimension1</TD><TD class="xl66" style="border-left-style: none; border-left-width: initial; border-left-color: initial;" width="67">Dimension2</TD><TD class="xl67" style="border-top-style: none; border-top-width: initial; border-top-color: initial; border-left-style: none; border-left-width: initial; border-left-color: initial;" width="44">Expr1</TD><TD class="xl71" style="border-top-style: none; border-top-width: initial; border-top-color: initial; border-left-style: none; border-left-width: initial; border-left-color: initial;" width="42">Expr2</TD><TD class="xl72" style="border-top-style: none; border-top-width: initial; border-top-color: initial; border-left-style: none; border-left-width: initial; border-left-color: initial;" width="47">Expr3</TD><TD class="xl75" style="border-top-style: none; border-top-width: initial; border-top-color: initial; border-left-style: none; border-left-width: initial; border-left-color: initial;" width="35">Expr4</TD><TD class="xl72" style="border-top-style: none; border-top-width: initial; border-top-color: initial;" width="47">Expr3</TD><TD class="xl75" style="border-top-style: none; border-top-width: initial; border-top-color: initial; border-left-style: none; border-left-width: initial; border-left-color: initial;" width="35">Expr4</TD><TD class="xl72" style="border-top-style: none; border-top-width: initial; border-top-color: initial;" width="47">Expr3</TD><TD class="xl76" style="border-top-style: none; border-top-width: initial; border-top-color: initial; border-left-style: none; border-left-width: initial; border-left-color: initial;" width="35">Expr4</TD><TD class="xl77" style="border-top-style: none; border-top-width: initial; border-top-color: initial;" width="62">Expr5</TD><TD class="xl78" style="border-top-style: none; border-top-width: initial; border-top-color: initial;" width="62">Expr6</TD><TD class="xl79" style="border-top-style: none; border-top-width: initial; border-top-color: initial; border-left-style: none; border-left-width: initial; border-left-color: initial;" width="62">Expr7</TD><TD class="xl81" style="border-top-style: none; border-top-width: initial; border-top-color: initial; border-left-style: none; border-left-width: initial; border-left-color: initial;" width="45">Expr8</TD></TR><TR><TD class="xl83" height="15">a</TD><TD class="xl85" style="border-left-style: none; border-left-width: initial; border-left-color: initial;">TOTAL</TD><TD align="right" class="xl86" style="border-left-style: none; border-left-width: initial; border-left-color: initial;"><BR /></TD><TD align="right" class="xl87"><BR /></TD><TD align="right" class="xl86"><BR /></TD><TD align="right" class="xl87"><BR /></TD><TD align="right" class="xl86"><BR /></TD><TD align="right" class="xl87"><BR /></TD><TD align="right" class="xl86"><BR /></TD><TD align="right" class="xl89"><BR /></TD><TD align="right" class="xl90" style="border-top-style: none; border-top-width: initial; border-top-color: initial;"><BR /></TD><TD align="right" class="xl91" style="border-top-style: none; border-top-width: initial; border-top-color: initial;"><BR /></TD><TD align="right" class="xl86"><BR /></TD><TD align="right" class="xl92" style="border-left-style: none; border-left-width: initial; border-left-color: initial;"><BR /></TD></TR><TR><TD class="xl83" height="15"></TD><TD class="xl85" style="border-left-style: none; border-left-width: initial; border-left-color: initial;">q</TD><TD align="right" class="xl86" style="border-left-style: none; border-left-width: initial; border-left-color: initial;"><BR /></TD><TD align="right" class="xl87"><BR /></TD><TD align="right" class="xl86"><BR /></TD><TD align="right" class="xl87"></TD><TD align="right" class="xl86"><BR /></TD><TD align="right" class="xl87"><BR /></TD><TD align="right" class="xl86"><BR /></TD><TD align="right" class="xl89"><BR /></TD><TD align="right" class="xl94"><BR /></TD><TD align="right" class="xl95"><BR /></TD><TD align="right" class="xl86"><BR /></TD><TD align="right" class="xl92" style="border-left-style: none; border-left-width: initial; border-left-color: initial;"><BR /></TD></TR><TR><TD class="xl83" height="15"></TD><TD class="xl85" style="border-left-style: none; border-left-width: initial; border-left-color: initial;">qw</TD><TD align="right" class="xl86" style="border-left-style: none; border-left-width: initial; border-left-color: initial;"><BR /></TD><TD align="right" class="xl87"><BR /></TD><TD align="right" class="xl86"><BR /></TD><TD align="right" class="xl87"><BR /></TD><TD align="right" class="xl86"><BR /></TD><TD align="right" class="xl87"><BR /></TD><TD align="right" class="xl86"><BR /></TD><TD align="right" class="xl89"><BR /></TD><TD align="right" class="xl94"><BR /></TD><TD align="right" class="xl95"><BR /></TD><TD align="right" class="xl86"><BR /></TD><TD align="right" class="xl92" style="border-left-style: none; border-left-width: initial; border-left-color: initial;"><BR /></TD></TR><TR><TD class="xl83" height="15"></TD><TD class="xl85" style="border-left-style: none; border-left-width: initial; border-left-color: initial;">qwe</TD><TD align="right" class="xl86" style="border-left-style: none; border-left-width: initial; border-left-color: initial;"><BR /></TD><TD align="right" class="xl87"><BR /></TD><TD align="right" class="xl86"><BR /></TD><TD align="right" class="xl87"></TD><TD align="right" class="xl86"><BR /></TD><TD align="right" class="xl87"><BR /></TD><TD align="right" class="xl86"><BR /></TD><TD align="right" class="xl89"><BR /></TD><TD align="right" class="xl94"><BR /></TD><TD align="right" class="xl95"><BR /></TD><TD align="right" class="xl86"><BR /></TD><TD align="right" class="xl92" style="border-left-style: none; border-left-width: initial; border-left-color: initial;"><BR /></TD></TR><TR><TD class="xl97" height="15">as</TD><TD class="xl98" style="border-left-style: none; border-left-width: initial; border-left-color: initial;">TOTAL</TD><TD align="right" class="xl96" style="border-left-style: none; border-left-width: initial; border-left-color: initial;"><BR /></TD><TD align="right" class="xl99"></TD><TD align="right" class="xl96"></TD><TD align="right" class="xl99"></TD><TD align="right" class="xl96"><BR /></TD><TD align="right" class="xl99"><BR /></TD><TD align="right" class="xl96"><BR /></TD><TD align="right" class="xl101"><BR /></TD><TD align="right" class="xl102"><BR /></TD><TD align="right" class="xl103"><BR /></TD><TD align="right" class="xl96"><BR /></TD><TD align="right" class="xl104" style="border-left-style: none; border-left-width: initial; border-left-color: initial;"><BR /></TD></TR><TR><TD class="xl83" height="15"></TD><TD class="xl85" style="border-left-style: none; border-left-width: initial; border-left-color: initial;">q</TD><TD align="right" class="xl86" style="border-left-style: none; border-left-width: initial; border-left-color: initial;"><BR /></TD><TD align="right" class="xl87"></TD><TD align="right" class="xl86"><BR /></TD><TD align="right" class="xl87"></TD><TD align="right" class="xl86"><BR /></TD><TD align="right" class="xl87"><BR /></TD><TD align="right" class="xl86"><BR /></TD><TD align="right" class="xl89"><BR /></TD><TD align="right" class="xl94"><BR /></TD><TD align="right" class="xl95"><BR /></TD><TD align="right" class="xl86"><BR /></TD><TD align="right" class="xl92" style="border-left-style: none; border-left-width: initial; border-left-color: initial;"><BR /></TD></TR><TR><TD class="xl83" height="15"></TD><TD class="xl85" style="border-left-style: none; border-left-width: initial; border-left-color: initial;">qw</TD><TD align="right" class="xl86" style="border-left-style: none; border-left-width: initial; border-left-color: initial;"><BR /></TD><TD align="right" class="xl87"></TD><TD align="right" class="xl86"><BR /></TD><TD align="right" class="xl87"></TD><TD align="right" class="xl86"><BR /></TD><TD align="right" class="xl87"><BR /></TD><TD align="right" class="xl86"><BR /></TD><TD align="right" class="xl89"><BR /></TD><TD align="right" class="xl94"><BR /></TD><TD align="right" class="xl95"><BR /></TD><TD align="right" class="xl86"><BR /></TD><TD align="right" class="xl92" style="border-left-style: none; border-left-width: initial; border-left-color: initial;"><BR /></TD></TR><TR><TD class="xl83" height="15"></TD><TD class="xl85" style="border-left-style: none; border-left-width: initial; border-left-color: initial;">qwe</TD><TD align="right" class="xl86" style="border-left-style: none; border-left-width: initial; border-left-color: initial;"><BR /></TD><TD align="right" class="xl87"></TD><TD align="right" class="xl86"><BR /></TD><TD align="right" class="xl87"></TD><TD align="right" class="xl86"><BR /></TD><TD align="right" class="xl87"><BR /></TD><TD align="right" class="xl86"><BR /></TD><TD align="right" class="xl89"><BR /></TD><TD align="right" class="xl94"><BR /></TD><TD align="right" class="xl95"><BR /></TD><TD align="right" class="xl86"><BR /></TD><TD align="right" class="xl92" style="border-left-style: none; border-left-width: initial; border-left-color: initial;"><BR /></TD></TR><TR><TD class="xl106" height="15">TOTAL</TD><TD class="xl107" style="border-left-style: none; border-left-width: initial; border-left-color: initial;"></TD><TD align="right" class="xl105" style="border-left-style: none; border-left-width: initial; border-left-color: initial;"><BR /></TD><TD align="right" class="xl108"></TD><TD align="right" class="xl105"></TD><TD align="right" class="xl108"></TD><TD align="right" class="xl105"><BR /></TD><TD align="right" class="xl108"><BR /></TD><TD align="right" class="xl105"><BR /></TD><TD align="right" class="xl110"><BR /></TD><TD align="right" class="xl111"><BR /></TD><TD align="right" class="xl112"><BR /></TD><TD align="right" class="xl105"><BR /></TD><TD align="right" class="xl113" style="border-left-style: none; border-left-width: initial; border-left-color: initial;"><BR /></TD></TR></TBODY></TABLE><P></P><P></P><P>Question: How to combine blocks, what groups of dimensions and groups of expression i need?</P></BODY></HTML> Fri, 06 Apr 2012 09:26:42 GMT https://community.qlik.com/t5/QlikView/Difficult-pivot-table/m-p/340838#M576644 2012-04-06T09:26:42Z Re: Difficult pivot table https://community.qlik.com/t5/QlikView/Difficult-pivot-table/m-p/340839#M576645 <HTML><HEAD></HEAD><BODY><P>ап</P></BODY></HTML> Thu, 06 Jun 2013 11:08:27 GMT https://community.qlik.com/t5/QlikView/Difficult-pivot-table/m-p/340839#M576645 2013-06-06T11:08:27Z Re: Difficult pivot table https://community.qlik.com/t5/QlikView/Difficult-pivot-table/m-p/340840#M576646 <HTML><HEAD></HEAD><BODY><P>ап</P></BODY></HTML> Thu, 06 Jun 2013 11:08:35 GMT https://community.qlik.com/t5/QlikView/Difficult-pivot-table/m-p/340840#M576646 2013-06-06T11:08:35Z