topic using the &lt;=(smaller or equal) in set analysis when comparing 2 fields with each other in QlikView https://community.qlik.com/t5/QlikView/using-the-lt-smaller-or-equal-in-set-analysis-when-comparing-2/m-p/221983#M74732 <HTML><HEAD></HEAD><BODY><P></P><P>This is the first part of my set analysis statement: Sum({&lt;CalYearWeek &lt;= {CurrentWeek}&gt;} total).</P><P>I want to determine a value based on all the weeks smaller or equal than the current week i'm in. Help with syntax around the &lt;= please.</P><P>Thankx,</P><P>Lambert.</P><BR /><BR /></BODY></HTML> Wed, 29 Sep 2010 13:09:11 GMT 2010-09-29T13:09:11Z using the <=(smaller or equal) in set analysis when comparing 2 fields with each other https://community.qlik.com/t5/QlikView/using-the-lt-smaller-or-equal-in-set-analysis-when-comparing-2/m-p/221983#M74732 <HTML><HEAD></HEAD><BODY><P></P><P>This is the first part of my set analysis statement: Sum({&lt;CalYearWeek &lt;= {CurrentWeek}&gt;} total).</P><P>I want to determine a value based on all the weeks smaller or equal than the current week i'm in. Help with syntax around the &lt;= please.</P><P>Thankx,</P><P>Lambert.</P><BR /><BR /></BODY></HTML> Wed, 29 Sep 2010 13:09:11 GMT https://community.qlik.com/t5/QlikView/using-the-lt-smaller-or-equal-in-set-analysis-when-comparing-2/m-p/221983#M74732 2010-09-29T13:09:11Z using the <=(smaller or equal) in set analysis when comparing 2 fields with each other https://community.qlik.com/t5/QlikView/using-the-lt-smaller-or-equal-in-set-analysis-when-comparing-2/m-p/221984#M74733 <HTML><HEAD></HEAD><BODY><P>Hello Lambert,</P><P>Use as follows</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">Sum({&lt;CalYearWeek = {'&gt;=$(CurrentWeek)'}&gt;} total)</PRE></BLOCKQUOTE><BR /><BR /> <P>having that CurrentWeek is a variable.</P><P>Hope that helps.</P></BODY></HTML> Wed, 29 Sep 2010 13:14:04 GMT https://community.qlik.com/t5/QlikView/using-the-lt-smaller-or-equal-in-set-analysis-when-comparing-2/m-p/221984#M74733 Miguel_Angel_Baeyens 2010-09-29T13:14:04Z using the <=(smaller or equal) in set analysis when comparing 2 fields with each other https://community.qlik.com/t5/QlikView/using-the-lt-smaller-or-equal-in-set-analysis-when-comparing-2/m-p/221985#M74734 <HTML><HEAD></HEAD><BODY><P>thanks, that was helpfull!</P></BODY></HTML> Wed, 29 Sep 2010 13:46:13 GMT https://community.qlik.com/t5/QlikView/using-the-lt-smaller-or-equal-in-set-analysis-when-comparing-2/m-p/221985#M74734 2010-09-29T13:46:13Z