Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

MTD

Hi All

   

Submited ByFalse Alert=[Sam Ref Id]
1158631: Degalesan, Raghunathan - 02/03/2015 10:48:28 PM#L2/L3 ApprovedSAM123102286552
1158631: Degalesan, Raghunathan - 02/03/2015 10:56:38 PM#L2/L3 ApprovedSAM123102286573
1158631: Degalesan, Raghunathan - 02/03/2015 11:21:16 PM#Auto ApprovedSAM123102286683
1163317: palanikumar raman - 05/03/2015 08:47:23 PM#L2/L3 ApprovedSAM529106947601
1166466: Srinivasan Gayathri - 03/03/2015 07:43:49 PM#L2/L3 ApprovedSAM123102289503
1166466: Srinivasan Gayathri - 04/03/2015 08:46:45 PM#L2/L3 ApprovedSAM123102293281
1166466: Srinivasan Gayathri - 08/03/2015 05:26:02 PM#L2/L3 ApprovedSAM123102303422
1166466: Srinivasan Gayathri - 25/03/2015 05:57:14 PM#L2/L3 ApprovedSAM123102303474
1166466: Srinivasan Gayathri - 26/03/2015 10:53:17 PM#L2/L3 ApprovedSAM123102304200
1166466: Srinivasan Gayathri - 16/04/2015 10:36:15 PM#L2/L3 ApprovedSAM123102327431
1166466: Srinivasan Gayathri - 17/04/2015 05:03:32 PM#L2/L3 ApprovedSAM124102328599
1166466: Srinivasan Gayathri - 18/04/2015 09:02:07 PM#SAM123102331772
1166466: Srinivasan Gayathri - 23/04/2015 05:18:10 PM#L2/L3 ApprovedSAM124102343668
1166466: Srinivasan Gayathri - 24/04/2015 04:29:35 PM#L2/L3 ApprovedSAM123102348301

Need to find the distinct Sam Ref Id for the Max Month and Previous Month where false Alert not equal to Auto Approved.

2 Replies
florentina_doga
Partner - Creator III
Partner - Creator III

I've attached  an example for this problem.

Not applicable
Author

HI

I want to find the Max Month MTD with Previous MTD