topic Less than/greater than in set analysis in QlikView https://community.qlik.com/t5/QlikView/Less-than-greater-than-in-set-analysis/m-p/918993#M318541 <HTML><HEAD></HEAD><BODY><P>Hello <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> </P><P></P><P>I thought this would be quite straight forward but this expression doesn't aggregate between January and the maximum <SPAN style="color: #993300;">MONTH</SPAN> of the <SPAN style="color: #993300;">YEAR</SPAN>.</P><P></P><P><SPAN style="color: #0000ff;">Sum</SPAN>({$&lt;<SPAN style="color: #993300;">YEAR</SPAN>={<SPAN style="color: #808080;"><STRONG><EM style="color: #999999;">$(=vMaxYear)</EM></STRONG></SPAN>}, <SPAN style="color: #993300;">MONTH</SPAN>={<SPAN style="color: #993300;">"&lt;=$(=vMaxMonth)"</SPAN>}&gt;} <SPAN style="color: #993300;">ACTIVITY</SPAN>)</P><P></P><P>This expression, however, works:</P><P><SPAN style="font-size: 13.3333330154419px; color: #0000ff;">Sum</SPAN><SPAN style="font-size: 13.3333330154419px;">({$&lt;</SPAN><SPAN style="font-size: 13.3333330154419px; color: #993300;">YEAR</SPAN><SPAN style="font-size: 13.3333330154419px;">={</SPAN><SPAN style="font-size: 13.3333330154419px; color: #808080;"><STRONG><EM style="color: #999999;">$(=vMaxYear)</EM></STRONG></SPAN><SPAN style="font-size: 13.3333330154419px;">}, </SPAN><SPAN style="font-size: 13.3333330154419px; color: #993300;">MONTH</SPAN><SPAN style="font-size: 13.3333330154419px;">={</SPAN><SPAN style="font-size: 13.3333330154419px; color: #993300;">"&lt;=7"</SPAN><SPAN style="font-size: 13.3333330154419px;">}&gt;} </SPAN><SPAN style="font-size: 13.3333330154419px; color: #993300;">ACTIVITY</SPAN><SPAN style="font-size: 13.3333330154419px;">)</SPAN></P></BODY></HTML> Tue, 11 Aug 2015 17:42:32 GMT jdmarlin 2015-08-11T17:42:32Z Less than/greater than in set analysis https://community.qlik.com/t5/QlikView/Less-than-greater-than-in-set-analysis/m-p/918993#M318541 <HTML><HEAD></HEAD><BODY><P>Hello <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> </P><P></P><P>I thought this would be quite straight forward but this expression doesn't aggregate between January and the maximum <SPAN style="color: #993300;">MONTH</SPAN> of the <SPAN style="color: #993300;">YEAR</SPAN>.</P><P></P><P><SPAN style="color: #0000ff;">Sum</SPAN>({$&lt;<SPAN style="color: #993300;">YEAR</SPAN>={<SPAN style="color: #808080;"><STRONG><EM style="color: #999999;">$(=vMaxYear)</EM></STRONG></SPAN>}, <SPAN style="color: #993300;">MONTH</SPAN>={<SPAN style="color: #993300;">"&lt;=$(=vMaxMonth)"</SPAN>}&gt;} <SPAN style="color: #993300;">ACTIVITY</SPAN>)</P><P></P><P>This expression, however, works:</P><P><SPAN style="font-size: 13.3333330154419px; color: #0000ff;">Sum</SPAN><SPAN style="font-size: 13.3333330154419px;">({$&lt;</SPAN><SPAN style="font-size: 13.3333330154419px; color: #993300;">YEAR</SPAN><SPAN style="font-size: 13.3333330154419px;">={</SPAN><SPAN style="font-size: 13.3333330154419px; color: #808080;"><STRONG><EM style="color: #999999;">$(=vMaxYear)</EM></STRONG></SPAN><SPAN style="font-size: 13.3333330154419px;">}, </SPAN><SPAN style="font-size: 13.3333330154419px; color: #993300;">MONTH</SPAN><SPAN style="font-size: 13.3333330154419px;">={</SPAN><SPAN style="font-size: 13.3333330154419px; color: #993300;">"&lt;=7"</SPAN><SPAN style="font-size: 13.3333330154419px;">}&gt;} </SPAN><SPAN style="font-size: 13.3333330154419px; color: #993300;">ACTIVITY</SPAN><SPAN style="font-size: 13.3333330154419px;">)</SPAN></P></BODY></HTML> Tue, 11 Aug 2015 17:42:32 GMT https://community.qlik.com/t5/QlikView/Less-than-greater-than-in-set-analysis/m-p/918993#M318541 jdmarlin 2015-08-11T17:42:32Z Re: Less than/greater than in set analysis https://community.qlik.com/t5/QlikView/Less-than-greater-than-in-set-analysis/m-p/918994#M318542 <HTML><HEAD></HEAD><BODY><P>Nevermind.. adding a '#' made it work <IMG src="https://community.qlik.com/legacyfs/online/emoticons/silly.png" /></P><P></P><P><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #0000ff;">Sum</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">({$&lt;</SPAN><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #993300;">YEAR</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">={</SPAN><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #808080;"><STRONG style="font-style: inherit; font-family: inherit;"><EM style="font-weight: inherit; font-family: inherit; color: #999999;">$(=vMaxYear)</EM></STRONG></SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">}, </SPAN><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #993300;">MONTH</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">={</SPAN><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #993300;">"&lt;=$(<STRONG>#</STRONG>=vMaxMonth)"</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">}&gt;} </SPAN><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #993300;">ACTIVITY</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">)</SPAN></P></BODY></HTML> Tue, 11 Aug 2015 17:44:42 GMT https://community.qlik.com/t5/QlikView/Less-than-greater-than-in-set-analysis/m-p/918994#M318542 jdmarlin 2015-08-11T17:44:42Z