topic Re: Alignment Issue for Secondary Dimension Total Values in QlikView https://community.qlik.com/t5/QlikView/Alignment-Issue-for-Secondary-Dimension-Total-Values/m-p/555662#M552798 <HTML><HEAD></HEAD><BODY><P>One trick is mark only one expression to show values and change the expression to something like:</P><P></P><P>dual(</P><P>&nbsp; sum(Expression1) &amp; chr(10) &amp; sum(Expression2),</P><P>&nbsp; sum(Expression1)</P><P>)</P><P>it´s important to uncheck any number format at Numbers Tab</P></BODY></HTML> Thu, 31 Oct 2013 15:08:44 GMT Clever_Anjos 2013-10-31T15:08:44Z Alignment Issue for Secondary Dimension Total Values https://community.qlik.com/t5/QlikView/Alignment-Issue-for-Secondary-Dimension-Total-Values/m-p/555661#M552797 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000000; font-family: 'Courier New', Courier, 'BB.Fixed Width.Gulim'; font-size: 13.004791259765625px;">Is there an easy way to align the values for Secondary Dimension totals in a bar chart? I attached an example of what Im trying to do. Thanks.</SPAN></P></BODY></HTML> Thu, 31 Oct 2013 15:04:51 GMT https://community.qlik.com/t5/QlikView/Alignment-Issue-for-Secondary-Dimension-Total-Values/m-p/555661#M552797 2013-10-31T15:04:51Z Re: Alignment Issue for Secondary Dimension Total Values https://community.qlik.com/t5/QlikView/Alignment-Issue-for-Secondary-Dimension-Total-Values/m-p/555662#M552798 <HTML><HEAD></HEAD><BODY><P>One trick is mark only one expression to show values and change the expression to something like:</P><P></P><P>dual(</P><P>&nbsp; sum(Expression1) &amp; chr(10) &amp; sum(Expression2),</P><P>&nbsp; sum(Expression1)</P><P>)</P><P>it´s important to uncheck any number format at Numbers Tab</P></BODY></HTML> Thu, 31 Oct 2013 15:08:44 GMT https://community.qlik.com/t5/QlikView/Alignment-Issue-for-Secondary-Dimension-Total-Values/m-p/555662#M552798 Clever_Anjos 2013-10-31T15:08:44Z Re: Re: Alignment Issue for Secondary Dimension Total Values https://community.qlik.com/t5/QlikView/Alignment-Issue-for-Secondary-Dimension-Total-Values/m-p/555663#M552799 <HTML><HEAD></HEAD><BODY><P>I altered my expression (which is written specifically to provide ONLY the total values) based on your advice above:</P><P></P><P>Dual(Sum([GLOBAL Efforts: Enhancement])&amp; Chr(10)&amp; Sum([GLOBAL Efforts: Mandatory]), Sum([GLOBAL Efforts: Enhancement]))</P><P></P><P>It appears my total values shifted down from their original location but still remain centered to the "Quarter" Dimension instead of the "Year".</P></BODY></HTML> Thu, 31 Oct 2013 15:21:47 GMT https://community.qlik.com/t5/QlikView/Alignment-Issue-for-Secondary-Dimension-Total-Values/m-p/555663#M552799 2013-10-31T15:21:47Z