topic Re: Set Analysis Inquiry in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-Inquiry/m-p/365803#M136098 <HTML><HEAD></HEAD><BODY><P>Use pivot table</P><P>Year,type as dimensions</P><P>Sum(amount) as Expression</P><P></P><P>Drag year and type to the top</P></BODY></HTML> Tue, 24 Jul 2012 17:28:03 GMT CELAMBARASAN 2012-07-24T17:28:03Z Set Analysis Inquiry https://community.qlik.com/t5/QlikView/Set-Analysis-Inquiry/m-p/365802#M136097 <HTML><HEAD></HEAD><BODY><P><IMG __jive_id="18820" class="jive-image" alt="4.png" src="https://community.qlik.com/legacyfs/online/18820_4.png" /></P><P>I can display data by year by using the following code: '=SUM({&lt;year = {2010} &gt;}amount).' I insert this code as an expression which gives me the year as a column-header. Pretty slick. Is it possible to add an additional level of granularity such as type? I would like to retain the year as a column-header with type A and B below. Thank you in advance for your assistance.</P><P></P><P>Don the Intern</P></BODY></HTML> Tue, 24 Jul 2012 17:17:03 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Inquiry/m-p/365802#M136097 2012-07-24T17:17:03Z Re: Set Analysis Inquiry https://community.qlik.com/t5/QlikView/Set-Analysis-Inquiry/m-p/365803#M136098 <HTML><HEAD></HEAD><BODY><P>Use pivot table</P><P>Year,type as dimensions</P><P>Sum(amount) as Expression</P><P></P><P>Drag year and type to the top</P></BODY></HTML> Tue, 24 Jul 2012 17:28:03 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Inquiry/m-p/365803#M136098 CELAMBARASAN 2012-07-24T17:28:03Z Re: Set Analysis Inquiry https://community.qlik.com/t5/QlikView/Set-Analysis-Inquiry/m-p/365804#M136099 <HTML><HEAD></HEAD><BODY><P>You are correct, but that does not really utilize 'set analysis.'</P></BODY></HTML> Tue, 24 Jul 2012 17:34:40 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Inquiry/m-p/365804#M136099 2012-07-24T17:34:40Z