topic Re: Expression in QlikView https://community.qlik.com/t5/QlikView/Expression/m-p/550160#M205485 <HTML><HEAD></HEAD><BODY><P>Sum({&lt;[Month]={"$(=Month(Today()))"}&gt;} Sales)</P><P>sum(&lt;$(=monthstart(today(),-1))</P><P></P><P>try this</P></BODY></HTML> Mon, 08 Jul 2013 10:39:06 GMT NavinReddy 2013-07-08T10:39:06Z Expression https://community.qlik.com/t5/QlikView/Expression/m-p/550158#M205483 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P></P><P>I have id's for Two months.but i need to get Current Month Id by Using Set Analysis.</P><P>can any one Help me</P><P></P><P></P><P>Thanks in advance</P><P>smiley</P></BODY></HTML> Mon, 08 Jul 2013 10:29:05 GMT https://community.qlik.com/t5/QlikView/Expression/m-p/550158#M205483 rathnam_qv 2013-07-08T10:29:05Z Re: Expression https://community.qlik.com/t5/QlikView/Expression/m-p/550159#M205484 <HTML><HEAD></HEAD><BODY><P>only({$&lt;Month={"=$(=month(today()))"}&gt;}id)</P></BODY></HTML> Mon, 08 Jul 2013 10:35:27 GMT https://community.qlik.com/t5/QlikView/Expression/m-p/550159#M205484 er_mohit 2013-07-08T10:35:27Z Re: Expression https://community.qlik.com/t5/QlikView/Expression/m-p/550160#M205485 <HTML><HEAD></HEAD><BODY><P>Sum({&lt;[Month]={"$(=Month(Today()))"}&gt;} Sales)</P><P>sum(&lt;$(=monthstart(today(),-1))</P><P></P><P>try this</P></BODY></HTML> Mon, 08 Jul 2013 10:39:06 GMT https://community.qlik.com/t5/QlikView/Expression/m-p/550160#M205485 NavinReddy 2013-07-08T10:39:06Z Re: Expression https://community.qlik.com/t5/QlikView/Expression/m-p/550161#M205486 <HTML><HEAD></HEAD><BODY><P>Please use the below mentioned Expression.</P><P></P><P>Count( {&lt;IDs = p({&lt;MonthField = {"$(=MAX(MonthField))"}&gt;})&nbsp;&nbsp; &gt;} Distinct IDs)</P><P></P><P></P><P>-Nilesh</P></BODY></HTML> Mon, 08 Jul 2013 10:59:55 GMT https://community.qlik.com/t5/QlikView/Expression/m-p/550161#M205486 nilesh_gangurde 2013-07-08T10:59:55Z