topic Re: Help On Set Analysis in QlikView https://community.qlik.com/t5/QlikView/Help-On-Set-Analysis/m-p/449845#M490446 <HTML><HEAD></HEAD><BODY><P>Field names are case sensitive, you have used your day field in lower and upper case, right?</P></BODY></HTML> Thu, 27 Sep 2012 17:09:59 GMT swuehl 2012-09-27T17:09:59Z Help On Set Analysis https://community.qlik.com/t5/QlikView/Help-On-Set-Analysis/m-p/449844#M490445 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>Need your help please, on this set :</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13487651162386228" jivemacro_uid="_13487651162386228"><P>=Sum({$&lt;Year = {$(=(Min(Year)))},MonthNr = {$(=(Min(MonthNr)))},day = {$(=(Min(Day)))}&gt;} nr_pmc_b)</P></PRE><P></P><P></P><P>the aim is to get un Sum on a selected date, taking the MIN of year,month and day.</P><P></P><P></P><P></P><P></P><P>Tnks</P></BODY></HTML> Thu, 27 Sep 2012 16:59:51 GMT https://community.qlik.com/t5/QlikView/Help-On-Set-Analysis/m-p/449844#M490445 Anonymous 2012-09-27T16:59:51Z Re: Help On Set Analysis https://community.qlik.com/t5/QlikView/Help-On-Set-Analysis/m-p/449845#M490446 <HTML><HEAD></HEAD><BODY><P>Field names are case sensitive, you have used your day field in lower and upper case, right?</P></BODY></HTML> Thu, 27 Sep 2012 17:09:59 GMT https://community.qlik.com/t5/QlikView/Help-On-Set-Analysis/m-p/449845#M490446 swuehl 2012-09-27T17:09:59Z