topic Calculated Dimension in QlikView https://community.qlik.com/t5/QlikView/Calculated-Dimension/m-p/1272541#M400134 <HTML><HEAD></HEAD><BODY><P>I am attempting to create a table using the following field.</P><P></P><P>promoCDE which has values such as 'Adult' 'MACBAN' 'FSTBRK'</P><P></P><P>I wan to build a table that has these different types of 'promoCDE' as the dimensions and then use the field =[Net Sold Qty] as the expression. My output would be:</P><P></P><P>promoCDE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [Net Sold Qty]</P><P>Adult&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; #,###</P><P>MACBAN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">#,###</SPAN></P><P>FSTBRK&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">#,###</SPAN></P></BODY></HTML> Tue, 14 Feb 2017 19:15:03 GMT evansabres 2017-02-14T19:15:03Z Calculated Dimension https://community.qlik.com/t5/QlikView/Calculated-Dimension/m-p/1272541#M400134 <HTML><HEAD></HEAD><BODY><P>I am attempting to create a table using the following field.</P><P></P><P>promoCDE which has values such as 'Adult' 'MACBAN' 'FSTBRK'</P><P></P><P>I wan to build a table that has these different types of 'promoCDE' as the dimensions and then use the field =[Net Sold Qty] as the expression. My output would be:</P><P></P><P>promoCDE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [Net Sold Qty]</P><P>Adult&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; #,###</P><P>MACBAN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">#,###</SPAN></P><P>FSTBRK&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">#,###</SPAN></P></BODY></HTML> Tue, 14 Feb 2017 19:15:03 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimension/m-p/1272541#M400134 evansabres 2017-02-14T19:15:03Z Re: Calculated Dimension https://community.qlik.com/t5/QlikView/Calculated-Dimension/m-p/1272542#M400135 <HTML><HEAD></HEAD><BODY><P>May be use set analysis instead</P><P></P><P>Dimension</P><P><STRONG>promoCDE</STRONG></P><P></P><P>Expression</P><P><STRONG>Sum({&lt;<SPAN style="font-size: 13.3333px;">promoCDE</SPAN> = {'<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Adult</SPAN>', '<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">MACBAN</SPAN>', 'FSTBRK'}&gt;}[Net Sold Qty])</STRONG></P></BODY></HTML> Tue, 14 Feb 2017 19:20:55 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimension/m-p/1272542#M400135 sunny_talwar 2017-02-14T19:20:55Z