topic Re: MTD in QlikView

topic Re: MTD in QlikView https://community.qlik.com/t5/QlikView/MTD/m-p/899273#M530735 <HTML><HEAD></HEAD><BODY><P>I've attached  an example for this problem.</P></BODY></HTML> Thu, 25 Jun 2015 10:50:12 GMT florentina_doga 2015-06-25T10:50:12Z MTD https://community.qlik.com/t5/QlikView/MTD/m-p/899272#M530734 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333330154419px;">Hi All </P><P style="font-size: 13.3333330154419px;">    </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 660px;"><TBODY><TR><TD height="20" width="435">Submited By</TD><TD width="104">False Alert</TD><TD width="121">=[Sam Ref Id]</TD></TR><TR><TD height="20">1158631: Degalesan, Raghunathan - 02/03/2015 10:48:28 PM#</TD><TD>L2/L3 Approved</TD><TD>SAM123102286552</TD></TR><TR><TD height="20">1158631: Degalesan, Raghunathan - 02/03/2015 10:56:38 PM#</TD><TD>L2/L3 Approved</TD><TD>SAM123102286573</TD></TR><TR><TD height="20">1158631: Degalesan, Raghunathan - 02/03/2015 11:21:16 PM#</TD><TD>Auto Approved</TD><TD>SAM123102286683</TD></TR><TR><TD height="20">1163317: palanikumar raman - 05/03/2015 08:47:23 PM#</TD><TD>L2/L3 Approved</TD><TD>SAM529106947601</TD></TR><TR><TD height="20">1166466: Srinivasan Gayathri - 03/03/2015 07:43:49 PM#</TD><TD>L2/L3 Approved</TD><TD>SAM123102289503</TD></TR><TR><TD height="20">1166466: Srinivasan Gayathri - 04/03/2015 08:46:45 PM#</TD><TD>L2/L3 Approved</TD><TD>SAM123102293281</TD></TR><TR><TD height="20">1166466: Srinivasan Gayathri - 08/03/2015 05:26:02 PM#</TD><TD>L2/L3 Approved</TD><TD>SAM123102303422</TD></TR><TR><TD height="20">1166466: Srinivasan Gayathri - 25/03/2015 05:57:14 PM#</TD><TD>L2/L3 Approved</TD><TD>SAM123102303474</TD></TR><TR><TD height="20">1166466: Srinivasan Gayathri - 26/03/2015 10:53:17 PM#</TD><TD>L2/L3 Approved</TD><TD>SAM123102304200</TD></TR><TR><TD height="20">1166466: Srinivasan Gayathri - 16/04/2015 10:36:15 PM#</TD><TD>L2/L3 Approved</TD><TD>SAM123102327431</TD></TR><TR><TD height="20">1166466: Srinivasan Gayathri - 17/04/2015 05:03:32 PM#</TD><TD>L2/L3 Approved</TD><TD>SAM124102328599</TD></TR><TR><TD height="20">1166466: Srinivasan Gayathri - 18/04/2015 09:02:07 PM#</TD><TD></TD><TD>SAM123102331772</TD></TR><TR><TD height="20">1166466: Srinivasan Gayathri - 23/04/2015 05:18:10 PM#</TD><TD>L2/L3 Approved</TD><TD>SAM124102343668</TD></TR><TR><TD height="20">1166466: Srinivasan Gayathri - 24/04/2015 04:29:35 PM#</TD><TD>L2/L3 Approved</TD><TD>SAM123102348301</TD></TR></TBODY></TABLE><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;">Need to find the distinct Sam Ref Id for the Max Month and Previous Month where false Alert not equal to Auto Approved.</P></BODY></HTML> Thu, 25 Jun 2015 09:16:41 GMT https://community.qlik.com/t5/QlikView/MTD/m-p/899272#M530734 2015-06-25T09:16:41Z Re: MTD https://community.qlik.com/t5/QlikView/MTD/m-p/899273#M530735 <HTML><HEAD></HEAD><BODY><P>I've attached  an example for this problem.</P></BODY></HTML> Thu, 25 Jun 2015 10:50:12 GMT https://community.qlik.com/t5/QlikView/MTD/m-p/899273#M530735 florentina_doga 2015-06-25T10:50:12Z Re: MTD https://community.qlik.com/t5/QlikView/MTD/m-p/899274#M530736 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P>I want to find the Max Month MTD with Previous MTD</P></BODY></HTML> Thu, 25 Jun 2015 12:11:07 GMT https://community.qlik.com/t5/QlikView/MTD/m-p/899274#M530736 2015-06-25T12:11:07Z