topic Set Analysis expression help in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-expression-help/m-p/217686#M70872 <HTML><HEAD></HEAD><BODY><P>Thanks Karl</P><P>Just what I was looking for</P><P>regards</P></BODY></HTML> Fri, 24 Sep 2010 15:58:54 GMT bismart 2010-09-24T15:58:54Z Set Analysis expression help https://community.qlik.com/t5/QlikView/Set-Analysis-expression-help/m-p/217684#M70870 <HTML><HEAD></HEAD><BODY><P>I have a transaction table with several years of transactions.</P><P>I want to create a measure which equates to the total of transactions up to and including selected Year &amp; month or Yearmonth, e.g. 201006 = June 2010.</P><P>Can anyone help please</P><P>Thanks</P></BODY></HTML> Fri, 24 Sep 2010 15:39:10 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-expression-help/m-p/217684#M70870 bismart 2010-09-24T15:39:10Z Set Analysis expression help https://community.qlik.com/t5/QlikView/Set-Analysis-expression-help/m-p/217685#M70871 <HTML><HEAD></HEAD><BODY><P>Bismart,</P><P>Try something like this...</P><P>sum({$&lt;Year=,Month=,Quarter=,MonthYear={"&lt;=$(#=max(MonthYear))"}&gt;} Amount)</P><P>Regards.</P></BODY></HTML> Fri, 24 Sep 2010 15:52:06 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-expression-help/m-p/217685#M70871 pover 2010-09-24T15:52:06Z Set Analysis expression help https://community.qlik.com/t5/QlikView/Set-Analysis-expression-help/m-p/217686#M70872 <HTML><HEAD></HEAD><BODY><P>Thanks Karl</P><P>Just what I was looking for</P><P>regards</P></BODY></HTML> Fri, 24 Sep 2010 15:58:54 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-expression-help/m-p/217686#M70872 bismart 2010-09-24T15:58:54Z