topic Set Analysis Expression for Regional Sales in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-Expression-for-Regional-Sales/m-p/588447#M218189 <HTML><HEAD></HEAD><BODY><P><BR />I have a chart that contains Region, Product and Sales. the sales amount is by product and region. I would like to add a column for regional sales based on the product selected. For example:</P><P></P><TABLE border="1" class="jiveBorder" style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; WIDTH: 100%; BORDER-TOP: #000000 1px solid; BORDER-RIGHT: #000000 1px solid;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG>Region</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG>Product</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG>Sales</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG>Regional Sales</STRONG></TH></TR><TR><TD style="padding: 2px;">North</TD><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">40</TD><TD style="padding: 2px;">100</TD></TR><TR><TD style="padding: 2px;">West</TD><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">50</TD><TD style="padding: 2px;">50</TD></TR><TR><TD style="padding: 2px;">North</TD><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">60</TD><TD style="padding: 2px;">100</TD></TR></TBODY></TABLE><P></P><P>I think I can add the new column with a Set Analysis expression. But I can't figure out the Set Analysis.&nbsp; Any ideas?&nbsp; Thanks! </P></BODY></HTML> Wed, 16 Apr 2014 19:47:11 GMT Anonymous 2014-04-16T19:47:11Z Set Analysis Expression for Regional Sales https://community.qlik.com/t5/QlikView/Set-Analysis-Expression-for-Regional-Sales/m-p/588447#M218189 <HTML><HEAD></HEAD><BODY><P><BR />I have a chart that contains Region, Product and Sales. the sales amount is by product and region. I would like to add a column for regional sales based on the product selected. For example:</P><P></P><TABLE border="1" class="jiveBorder" style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; WIDTH: 100%; BORDER-TOP: #000000 1px solid; BORDER-RIGHT: #000000 1px solid;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG>Region</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG>Product</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG>Sales</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG>Regional Sales</STRONG></TH></TR><TR><TD style="padding: 2px;">North</TD><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">40</TD><TD style="padding: 2px;">100</TD></TR><TR><TD style="padding: 2px;">West</TD><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">50</TD><TD style="padding: 2px;">50</TD></TR><TR><TD style="padding: 2px;">North</TD><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">60</TD><TD style="padding: 2px;">100</TD></TR></TBODY></TABLE><P></P><P>I think I can add the new column with a Set Analysis expression. But I can't figure out the Set Analysis.&nbsp; Any ideas?&nbsp; Thanks! </P></BODY></HTML> Wed, 16 Apr 2014 19:47:11 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Expression-for-Regional-Sales/m-p/588447#M218189 Anonymous 2014-04-16T19:47:11Z Re: Set Analysis Expression for Regional Sales https://community.qlik.com/t5/QlikView/Set-Analysis-Expression-for-Regional-Sales/m-p/588448#M218190 <HTML><HEAD></HEAD><BODY><P>sum (total &lt;Region&gt; Sales)</P></BODY></HTML> Wed, 16 Apr 2014 19:51:16 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Expression-for-Regional-Sales/m-p/588448#M218190 maxgro 2014-04-16T19:51:16Z Re: Set Analysis Expression for Regional Sales https://community.qlik.com/t5/QlikView/Set-Analysis-Expression-for-Regional-Sales/m-p/588449#M218191 <HTML><HEAD></HEAD><BODY><P><BR />Thank you. That was simple and just what I needed!</P></BODY></HTML> Wed, 16 Apr 2014 19:55:13 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Expression-for-Regional-Sales/m-p/588449#M218191 Anonymous 2014-04-16T19:55:13Z