topic Help with Set Analysis in QlikView https://community.qlik.com/t5/QlikView/Help-with-Set-Analysis/m-p/490594#M1125247 <HTML><HEAD></HEAD><BODY><P><BR />Hi</P><P></P><P>I have a field called 'Period' which represents financial reporting periods within a year and they are numbered 1 to 12. I want a chart to only show periods 1 to 6. What is the set analysis for this?</P><P></P><P>Thanks</P></BODY></HTML> Thu, 09 Jan 2014 15:59:47 GMT Anonymous 2014-01-09T15:59:47Z Help with Set Analysis https://community.qlik.com/t5/QlikView/Help-with-Set-Analysis/m-p/490594#M1125247 <HTML><HEAD></HEAD><BODY><P><BR />Hi</P><P></P><P>I have a field called 'Period' which represents financial reporting periods within a year and they are numbered 1 to 12. I want a chart to only show periods 1 to 6. What is the set analysis for this?</P><P></P><P>Thanks</P></BODY></HTML> Thu, 09 Jan 2014 15:59:47 GMT https://community.qlik.com/t5/QlikView/Help-with-Set-Analysis/m-p/490594#M1125247 Anonymous 2014-01-09T15:59:47Z Re: Help with Set Analysis https://community.qlik.com/t5/QlikView/Help-with-Set-Analysis/m-p/490595#M1125248 <HTML><HEAD></HEAD><BODY><P>{&lt;Period = {"&gt;=1&lt;=6"} &gt;}</P><P></P><P>added to your expression's aggregation functions, like</P><P></P><P>=sum( {&lt;Period = {"&gt;=1&lt;=6"} &gt;} Amount)</P></BODY></HTML> Thu, 09 Jan 2014 16:01:41 GMT https://community.qlik.com/t5/QlikView/Help-with-Set-Analysis/m-p/490595#M1125248 swuehl 2014-01-09T16:01:41Z