topic Re: simple set in QlikView https://community.qlik.com/t5/QlikView/simple-set/m-p/971095#M332450 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>=Sum({$&lt;Period = {"&gt;0&lt;=13"}&gt;}BS_Budget)</STRONG></P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/103173_Capture.PNG" style="height: 244px; width: 620px;" /></P></BODY></HTML> Tue, 27 Oct 2015 12:01:03 GMT sunny_talwar 2015-10-27T12:01:03Z simple set https://community.qlik.com/t5/QlikView/simple-set/m-p/971094#M332449 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I need some suggestions on set analysis expression</P><P>i have a chart that should be changed </P></BODY></HTML> Tue, 27 Oct 2015 11:56:38 GMT https://community.qlik.com/t5/QlikView/simple-set/m-p/971094#M332449 2015-10-27T11:56:38Z Re: simple set https://community.qlik.com/t5/QlikView/simple-set/m-p/971095#M332450 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>=Sum({$&lt;Period = {"&gt;0&lt;=13"}&gt;}BS_Budget)</STRONG></P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/103173_Capture.PNG" style="height: 244px; width: 620px;" /></P></BODY></HTML> Tue, 27 Oct 2015 12:01:03 GMT https://community.qlik.com/t5/QlikView/simple-set/m-p/971095#M332450 sunny_talwar 2015-10-27T12:01:03Z Re: simple set https://community.qlik.com/t5/QlikView/simple-set/m-p/971096#M332451 <HTML><HEAD></HEAD><BODY><P>Hi, I'm not sure of what you want, maybe with this expression?:</P><P>=if(MAx(TOTAL [Period]) &lt;= 13 and Min(TOTAL [Period])&lt;&gt; 00,Sum({$&lt;Period=&gt;}BS_Budget),0)</P><P></P><P>If the values selected contains '0' or '13' it will show '0', in any other case it makes Sum({$&lt;Period=&gt;}BS_Budget)</P></BODY></HTML> Tue, 27 Oct 2015 12:04:28 GMT https://community.qlik.com/t5/QlikView/simple-set/m-p/971096#M332451 rubenmarin 2015-10-27T12:04:28Z