topic Re: Expression/Dimension Help in QlikView https://community.qlik.com/t5/QlikView/Expression-Dimension-Help/m-p/1410518#M817872 <HTML><HEAD></HEAD><BODY><P>Hi Gareth,</P><P>You're very welcome!</P><P>Cheers</P><P></P><P>Andrew</P></BODY></HTML> Wed, 30 Aug 2017 13:15:50 GMT effinty2112 2017-08-30T13:15:50Z Expression/Dimension Help https://community.qlik.com/t5/QlikView/Expression-Dimension-Help/m-p/1410515#M817869 <HTML><HEAD></HEAD><BODY><P>Hi guys</P><P></P><P>If I was to put the Supplier Name and Spend columns from the attached into a straight table, how would I show AFC Ajax on one row, and all the others added together on another?</P><P><BR />Thanks in advance,</P><P>Gareth</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Expression-Dimension-Help/m-p/1410515#M817869 Anonymous 2020-11-25T16:16:04Z Re: Expression/Dimension Help https://community.qlik.com/t5/QlikView/Expression-Dimension-Help/m-p/1410516#M817870 <HTML><HEAD></HEAD><BODY><P>Hi Gareth,</P><P>Use a calculated dimension:</P><P>=Aggr(If([Supplier Name] = 'AFC Ajax',[Supplier Name],'Other'),[Supplier Name])</P><P></P><P>to get:</P><P></P><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="font-size: 9pt;"><TBODY><TR bgcolor="#f5f5f5"><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Supplier Name</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Sum ([Spend (£)])</STRONG></SPAN><STRONG> </STRONG></TH></TR><TR bgcolor="#f5f5f5"><TD bgcolor="#f5f5f5"> </TD><TD bgcolor="#f5f5f5"><STRONG>£3602388.42 </STRONG></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Other</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">£3524562.42</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">AFC Ajax</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">£77826.00</SPAN></TD></TR></TBODY></TABLE><P></P><P>Cheers</P><P></P><P>Andrew</P></BODY></HTML> Wed, 30 Aug 2017 13:10:49 GMT https://community.qlik.com/t5/QlikView/Expression-Dimension-Help/m-p/1410516#M817870 effinty2112 2017-08-30T13:10:49Z Re: Expression/Dimension Help https://community.qlik.com/t5/QlikView/Expression-Dimension-Help/m-p/1410517#M817871 <HTML><HEAD></HEAD><BODY><P>Hi Andrew,</P><P><BR />That's brilliant - thanks very much.</P><P></P><P>Cheers</P><P>Gareth</P></BODY></HTML> Wed, 30 Aug 2017 13:15:03 GMT https://community.qlik.com/t5/QlikView/Expression-Dimension-Help/m-p/1410517#M817871 Anonymous 2017-08-30T13:15:03Z Re: Expression/Dimension Help https://community.qlik.com/t5/QlikView/Expression-Dimension-Help/m-p/1410518#M817872 <HTML><HEAD></HEAD><BODY><P>Hi Gareth,</P><P>You're very welcome!</P><P>Cheers</P><P></P><P>Andrew</P></BODY></HTML> Wed, 30 Aug 2017 13:15:50 GMT https://community.qlik.com/t5/QlikView/Expression-Dimension-Help/m-p/1410518#M817872 effinty2112 2017-08-30T13:15:50Z