topic Set Analysis in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/199034#M58131 <HTML><HEAD></HEAD><BODY><P>Hello,<BR /><BR /></P><P>I have a problem with following script</P><P>=Sum ({$&lt; TXT = {"Sales"}, AccMonth={$(Month1)} &gt; } AccRowsDebitRowSum)<BR /><BR /><BR />I want to sum all the values that are less than or equal to the variable $ (Month1)</P><BR /><BR /> <P></P><P>How to do it</P><P></P></BODY></HTML> Wed, 31 Mar 2010 11:35:08 GMT dradoikov 2010-03-31T11:35:08Z Set Analysis https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/199034#M58131 <HTML><HEAD></HEAD><BODY><P>Hello,<BR /><BR /></P><P>I have a problem with following script</P><P>=Sum ({$&lt; TXT = {"Sales"}, AccMonth={$(Month1)} &gt; } AccRowsDebitRowSum)<BR /><BR /><BR />I want to sum all the values that are less than or equal to the variable $ (Month1)</P><BR /><BR /> <P></P><P>How to do it</P><P></P></BODY></HTML> Wed, 31 Mar 2010 11:35:08 GMT https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/199034#M58131 dradoikov 2010-03-31T11:35:08Z Set Analysis https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/199035#M58132 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>try something like this:</P><P>=Sum ({$&lt; TXT = {"Sales"}, AccMonth={"&lt;=$(Month1)"} &gt; } AccRowsDebitRowSum)</P><P>If it not work upload an example please.</P><P>Good luck!</P><P>Rainer<BR /></P></BODY></HTML> Wed, 31 Mar 2010 11:48:25 GMT https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/199035#M58132 2010-03-31T11:48:25Z Set Analysis https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/199036#M58133 <HTML><HEAD></HEAD><BODY><P>Works!<BR /><BR />Thank you very much</P><P>Daniel</P></BODY></HTML> Wed, 31 Mar 2010 13:15:16 GMT https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/199036#M58133 dradoikov 2010-03-31T13:15:16Z