topic Re: Set Analysis Question in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-Question/m-p/395403#M490306 <HTML><HEAD></HEAD><BODY><P>brilliant - working now thank you both</P></BODY></HTML> Wed, 10 Oct 2012 10:05:44 GMT 2012-10-10T10:05:44Z Set Analysis Question https://community.qlik.com/t5/QlikView/Set-Analysis-Question/m-p/395400#M490303 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt;">Hi,</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">I'm trying to get a simple set analysis expression to work.&nbsp; All I want to do is show the current days average regardless of the selection criteria chosen.&nbsp; I tried the formula but when I change dates the calculation changes.&nbsp; </SPAN></P><P></P><P><SPAN style="font-size: 10pt;">avg({1&lt; <SPAN style="color: #800000;">KeyDate</SPAN>={'=date(today())'}&gt;} <SPAN style="color: #800000;">HA1</SPAN>) / 100 </SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Can anyone help me to get this working?</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Thanks,</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Pete</SPAN></P></BODY></HTML> Tue, 09 Oct 2012 15:49:10 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Question/m-p/395400#M490303 2012-10-09T15:49:10Z Re: Set Analysis Question https://community.qlik.com/t5/QlikView/Set-Analysis-Question/m-p/395401#M490304 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><SPAN style="font-size: 10pt;">avg({1&lt; <SPAN style="color: #800000;">KeyDate</SPAN>={$(=date(today()))}&gt;} <SPAN style="color: #800000;">HA1</SPAN>) / 100</SPAN></P></BODY></HTML> Tue, 09 Oct 2012 15:55:43 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Question/m-p/395401#M490304 2012-10-09T15:55:43Z Re: Set Analysis Question https://community.qlik.com/t5/QlikView/Set-Analysis-Question/m-p/395402#M490305 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>PFA, hope it helps you.</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Tue, 09 Oct 2012 15:57:12 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Question/m-p/395402#M490305 jagan 2012-10-09T15:57:12Z Re: Set Analysis Question https://community.qlik.com/t5/QlikView/Set-Analysis-Question/m-p/395403#M490306 <HTML><HEAD></HEAD><BODY><P>brilliant - working now thank you both</P></BODY></HTML> Wed, 10 Oct 2012 10:05:44 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Question/m-p/395403#M490306 2012-10-10T10:05:44Z