topic Re: Set Analysis in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/747510#M1046011 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Let vDate=Max(x);</P><P></P><P>avg({&lt;Date={'=&lt;($(vDate))'}&gt;} Population)</P></BODY></HTML> Fri, 14 Nov 2014 10:55:57 GMT 2014-11-14T10:55:57Z Set Analysis https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/747509#M1046010 <HTML><HEAD></HEAD><BODY><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">How can we write set analysis expression for showing Avg(Population) for dates less than X.</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">For example, if I have population value at 3 different dates (W, X, Z), I would like to show Avg(Population) for all the dates less than X. Average value should not include population value at Z.</P></BODY></HTML> Fri, 14 Nov 2014 10:37:17 GMT https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/747509#M1046010 2014-11-14T10:37:17Z Re: Set Analysis https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/747510#M1046011 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Let vDate=Max(x);</P><P></P><P>avg({&lt;Date={'=&lt;($(vDate))'}&gt;} Population)</P></BODY></HTML> Fri, 14 Nov 2014 10:55:57 GMT https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/747510#M1046011 2014-11-14T10:55:57Z