topic Re: ACTUAL MONTH IN SET ANALISYS in QlikView https://community.qlik.com/t5/QlikView/ACTUAL-MONTH-IN-SET-ANALISYS/m-p/771215#M1045579 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Sum({&lt;[Mes Año]= {"$(=date(max([Mes Año]), 'MMM-YYYY'))"}&gt;} sales)</SPAN></P></BODY></HTML> Wed, 03 Dec 2014 23:53:50 GMT simenkg 2014-12-03T23:53:50Z ACTUAL MONTH IN SET ANALISYS https://community.qlik.com/t5/QlikView/ACTUAL-MONTH-IN-SET-ANALISYS/m-p/771214#M1045578 <HTML><HEAD></HEAD><BODY><P>Hi expert, i have an object that i simply show the sales for the actual month year</P><P></P><P>i am using set analisys</P><P></P><P>Sum({&lt;[Mes Año]= date(max([Mes Año]), 'MMM-YYYY')&gt;}, sales)</P><P></P><P>where is the error? </P><P></P><P>thank you a lot</P><P></P><P>Fernando</P></BODY></HTML> Wed, 03 Dec 2014 23:51:45 GMT https://community.qlik.com/t5/QlikView/ACTUAL-MONTH-IN-SET-ANALISYS/m-p/771214#M1045578 fkeuroglian 2014-12-03T23:51:45Z Re: ACTUAL MONTH IN SET ANALISYS https://community.qlik.com/t5/QlikView/ACTUAL-MONTH-IN-SET-ANALISYS/m-p/771215#M1045579 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Sum({&lt;[Mes Año]= {"$(=date(max([Mes Año]), 'MMM-YYYY'))"}&gt;} sales)</SPAN></P></BODY></HTML> Wed, 03 Dec 2014 23:53:50 GMT https://community.qlik.com/t5/QlikView/ACTUAL-MONTH-IN-SET-ANALISYS/m-p/771215#M1045579 simenkg 2014-12-03T23:53:50Z