topic Re: MTD in QlikView

topic Re: MTD in QlikView https://community.qlik.com/t5/QlikView/MTD/m-p/900271#M530666 <HTML><HEAD></HEAD><BODY><P>Hi </P><P>Thanks for your help.</P><P>If i select any month , the Previous Month value is not displayed.</P><P>Can you help me out on this</P></BODY></HTML> Sun, 28 Jun 2015 17:16:45 GMT 2015-06-28T17:16:45Z MTD https://community.qlik.com/t5/QlikView/MTD/m-p/900268#M530663 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333330154419px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Hi All</P><P style="font-size: 13.3333330154419px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">   </P><TABLE border="0" cellpadding="0" cellspacing="0" style="border: 0px; font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><TBODY style="font-weight: inherit; font-style: inherit; font-family: inherit;"><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD height="20" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;" width="435">Submited By</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;" width="104">False Alert</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;" width="121">=[Sam Ref Id]</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD height="20" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">1158631: Degalesan, Raghunathan - 02/03/2015 10:48:28 PM#</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">L2/L3 Approved</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">SAM123102286552</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD height="20" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">1158631: Degalesan, Raghunathan - 02/03/2015 10:56:38 PM#</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">L2/L3 Approved</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">SAM123102286573</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD height="20" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">1158631: Degalesan, Raghunathan - 02/03/2015 11:21:16 PM#</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">Auto Approved</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">SAM123102286683</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD height="20" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">1163317: palanikumar raman - 05/03/2015 08:47:23 PM#</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">L2/L3 Approved</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">SAM529106947601</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD height="20" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">1166466: Srinivasan Gayathri - 03/03/2015 07:43:49 PM#</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">L2/L3 Approved</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">SAM123102289503</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD height="20" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">1166466: Srinivasan Gayathri - 04/03/2015 08:46:45 PM#</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">L2/L3 Approved</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">SAM123102293281</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD height="20" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">1166466: Srinivasan Gayathri - 08/03/2015 05:26:02 PM#</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">L2/L3 Approved</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">SAM123102303422</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD height="20" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">1166466: Srinivasan Gayathri - 25/03/2015 05:57:14 PM#</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">L2/L3 Approved</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">SAM123102303474</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD height="20" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">1166466: Srinivasan Gayathri - 26/03/2015 10:53:17 PM#</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">L2/L3 Approved</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">SAM123102304200</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD height="20" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">1166466: Srinivasan Gayathri - 16/04/2015 10:36:15 PM#</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">L2/L3 Approved</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">SAM123102327431</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD height="20" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">1166466: Srinivasan Gayathri - 17/04/2015 05:03:32 PM#</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">L2/L3 Approved</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">SAM124102328599</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD height="20" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">1166466: Srinivasan Gayathri - 18/04/2015 09:02:07 PM#</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;"></TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">SAM123102331772</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD height="20" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">1166466: Srinivasan Gayathri - 23/04/2015 05:18:10 PM#</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">L2/L3 Approved</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">SAM124102343668</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD height="20" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">1166466: Srinivasan Gayathri - 24/04/2015 04:29:35 PM#</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">L2/L3 Approved</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">SAM123102348301</TD></TR></TBODY></TABLE><P></P><P style="font-size: 13.3333330154419px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Need to find the distinct Sam Ref Id for the MTD of Max Month and MTD of  Previous Month where false Alert not equal to Auto Approved.</P><P style="font-size: 13.3333330154419px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">In the above example April all data and March excluding 25th and 26th</P></BODY></HTML> Thu, 25 Jun 2015 12:16:12 GMT https://community.qlik.com/t5/QlikView/MTD/m-p/900268#M530663 2015-06-25T12:16:12Z Re: MTD https://community.qlik.com/t5/QlikView/MTD/m-p/900269#M530664 <HTML><HEAD></HEAD><BODY><P>Hi Senthil, please check attachment (script and text boxes). Hope this helps!</P></BODY></HTML> Thu, 25 Jun 2015 12:50:32 GMT https://community.qlik.com/t5/QlikView/MTD/m-p/900269#M530664 rubenmarin 2015-06-25T12:50:32Z Re: MTD https://community.qlik.com/t5/QlikView/MTD/m-p/900270#M530665 <HTML><HEAD></HEAD><BODY><P>hope this help?</P><P>i use a variable dataref.</P></BODY></HTML> Thu, 25 Jun 2015 12:59:50 GMT https://community.qlik.com/t5/QlikView/MTD/m-p/900270#M530665 florentina_doga 2015-06-25T12:59:50Z Re: MTD https://community.qlik.com/t5/QlikView/MTD/m-p/900271#M530666 <HTML><HEAD></HEAD><BODY><P>Hi </P><P>Thanks for your help.</P><P>If i select any month , the Previous Month value is not displayed.</P><P>Can you help me out on this</P></BODY></HTML> Sun, 28 Jun 2015 17:16:45 GMT https://community.qlik.com/t5/QlikView/MTD/m-p/900271#M530666 2015-06-28T17:16:45Z Re: MTD https://community.qlik.com/t5/QlikView/MTD/m-p/900272#M530667 <HTML><HEAD></HEAD><BODY><P>Hi, You can ignore Month selections in set analisys:</P><P>Count(DISTINCT {<Date={'>=$(=MonthStart(AddMonths(Max(Date), -1)))<=$(=Date(AddMonths(Max(Date), -1)))'}, <STRONG>Month</STRONG>>}  [Sam Ref Id])</P><P></P><P>Change the bolded 'Month' to the name of your month field, maybe you want to ignore other selections like quarter, year...</P></BODY></HTML> Sun, 28 Jun 2015 18:25:02 GMT https://community.qlik.com/t5/QlikView/MTD/m-p/900272#M530667 rubenmarin 2015-06-28T18:25:02Z