topic Re: Alignment with pivot table in QlikView https://community.qlik.com/t5/QlikView/Alignment-with-pivot-table/m-p/997038#M339148 <HTML><HEAD></HEAD><BODY><P>First, create the pivot table:</P><P>- Dimension: Dept</P><P>- Expressions: Sum (Sales) and %</P><P></P><P><IMG alt="p49.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/97004_p49.png" style="height: auto;" /></P><P>second, dragging the (Dept) column to bring it above the columns</P><P>third column format</P></BODY></HTML> Wed, 26 Aug 2015 08:36:58 GMT ecolomer 2015-08-26T08:36:58Z Alignment with pivot table https://community.qlik.com/t5/QlikView/Alignment-with-pivot-table/m-p/997032#M339142 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I need assistance in&nbsp; alignment of&nbsp; dimension in pivot table .</P><P>Please find the attacment for understanding the problem</P><P></P><P></P><P>Thanks </P></BODY></HTML> Wed, 26 Aug 2015 06:58:02 GMT https://community.qlik.com/t5/QlikView/Alignment-with-pivot-table/m-p/997032#M339142 Anonymous 2015-08-26T06:58:02Z Re: Alignment with pivot table https://community.qlik.com/t5/QlikView/Alignment-with-pivot-table/m-p/997033#M339143 <HTML><HEAD></HEAD><BODY><P>Can you explain better your requieriment, please?</P><P>or upload a example to work with it</P></BODY></HTML> Wed, 26 Aug 2015 07:04:53 GMT https://community.qlik.com/t5/QlikView/Alignment-with-pivot-table/m-p/997033#M339143 ecolomer 2015-08-26T07:04:53Z Re: Alignment with pivot table https://community.qlik.com/t5/QlikView/Alignment-with-pivot-table/m-p/997034#M339144 <HTML><HEAD></HEAD><BODY><P>Hi <A href="https://community.qlik.com/qlik-users/34135">ecolomer</A></P><P></P><P>This is current design .</P><P></P><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="font-size: 9pt;"><TBODY><TR bgcolor="#f5f5f5"><TH bgcolor="#e1e1e1" nowrap="nowrap"><SPAN style="color: #000000;"><STRONG>Dept</STRONG></SPAN><STRONG> </STRONG></TH><TD bgcolor="#f5f5f5">Sales</TD><TD bgcolor="#f5f5f5">[Sales %]</TD></TR><TR bgcolor="#f5f5f5"><TD bgcolor="#f5f5f5">Admim</TD><TD bgcolor="#f5f5f5">100</TD><TD bgcolor="#f5f5f5">10%</TD></TR><TR bgcolor="#f5f5f5"><TD bgcolor="#f5f5f5">Dev</TD><TD bgcolor="#f5f5f5">200</TD><TD bgcolor="#f5f5f5">20%</TD></TR><TR bgcolor="#f5f5f5"><TD bgcolor="#f5f5f5">Finance</TD><TD bgcolor="#f5f5f5">300</TD><TD bgcolor="#f5f5f5">305</TD></TR></TBODY></TABLE><P></P><P></P><P></P><P>Below is the desired output</P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/96993_pastedImage_1.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>Thanks</P></BODY></HTML> Wed, 26 Aug 2015 07:52:19 GMT https://community.qlik.com/t5/QlikView/Alignment-with-pivot-table/m-p/997034#M339144 Anonymous 2015-08-26T07:52:19Z Re: Alignment with pivot table https://community.qlik.com/t5/QlikView/Alignment-with-pivot-table/m-p/997035#M339145 <HTML><HEAD></HEAD><BODY><P>Is this?</P><P><IMG alt="p48.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/96994_p48.png" style="height: 278px; width: 620px;" /></P></BODY></HTML> Wed, 26 Aug 2015 08:00:58 GMT https://community.qlik.com/t5/QlikView/Alignment-with-pivot-table/m-p/997035#M339145 ecolomer 2015-08-26T08:00:58Z Re: Alignment with pivot table https://community.qlik.com/t5/QlikView/Alignment-with-pivot-table/m-p/997036#M339146 <HTML><HEAD></HEAD><BODY><P>Hi, <SPAN class="j-post-author"><STRONG><A href="https://community.qlik.com/people/rgvavihs">rgvavihs</A></STRONG></SPAN></P><P></P><P>For each Dimension and Expression set Alingment to Center under Chart Properties-&gt;Presentation.</P><P></P><P><IMG __jive_id="97001" alt="" class="jive-image image-1" height="157" src="https://community.qlik.com/legacyfs/online/97001_pastedImage_1.png" style="max-width: 1200px; max-height: 900px; width: 542px; height: 156.855px;" width="542" /></P></BODY></HTML> Wed, 26 Aug 2015 08:12:29 GMT https://community.qlik.com/t5/QlikView/Alignment-with-pivot-table/m-p/997036#M339146 daniel_kusiak 2015-08-26T08:12:29Z Re: Alignment with pivot table https://community.qlik.com/t5/QlikView/Alignment-with-pivot-table/m-p/997037#M339147 <HTML><HEAD></HEAD><BODY><P>Dear Enrique,</P><P></P><P>Please explain the steps !</P><P></P><P>Thanks </P></BODY></HTML> Wed, 26 Aug 2015 08:14:55 GMT https://community.qlik.com/t5/QlikView/Alignment-with-pivot-table/m-p/997037#M339147 Anonymous 2015-08-26T08:14:55Z Re: Alignment with pivot table https://community.qlik.com/t5/QlikView/Alignment-with-pivot-table/m-p/997038#M339148 <HTML><HEAD></HEAD><BODY><P>First, create the pivot table:</P><P>- Dimension: Dept</P><P>- Expressions: Sum (Sales) and %</P><P></P><P><IMG alt="p49.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/97004_p49.png" style="height: auto;" /></P><P>second, dragging the (Dept) column to bring it above the columns</P><P>third column format</P></BODY></HTML> Wed, 26 Aug 2015 08:36:58 GMT https://community.qlik.com/t5/QlikView/Alignment-with-pivot-table/m-p/997038#M339148 ecolomer 2015-08-26T08:36:58Z