topic Re: Help needed with Max Date trigger in QlikView https://community.qlik.com/t5/QlikView/Help-needed-with-Max-Date-trigger/m-p/1010957#M343040 <HTML><HEAD></HEAD><BODY><P>I tried this and didnt work<IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/107668_Capture.PNG" style="height: 210px; width: 620px;" /></P></BODY></HTML> Mon, 30 Nov 2015 19:50:48 GMT 2015-11-30T19:50:48Z Help needed with Max Date trigger https://community.qlik.com/t5/QlikView/Help-needed-with-Max-Date-trigger/m-p/1010954#M343037 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I have the following data and I need to create a trigger that when the user selects a <STRONG><EM>month</EM></STRONG>, it selects on the <EM><STRONG>close_date_cal2</STRONG></EM> field the <STRONG>max date for each of the client</STRONG>, but as you can see it is selecting two for 120 and I just need the one from January 23rd. </P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/107658_Capture.PNG" style="height: auto;" /></P><P></P><P>Again, I need to create it as a trigger on the selection of the month field. </P><P></P><P>Thanks and regards, </P></BODY></HTML> Mon, 30 Nov 2015 18:47:40 GMT https://community.qlik.com/t5/QlikView/Help-needed-with-Max-Date-trigger/m-p/1010954#M343037 2015-11-30T18:47:40Z Re: Help needed with Max Date trigger https://community.qlik.com/t5/QlikView/Help-needed-with-Max-Date-trigger/m-p/1010955#M343038 <HTML><HEAD></HEAD><BODY><P>may be FirstSortedValue can helpful !</P></BODY></HTML> Mon, 30 Nov 2015 19:15:19 GMT https://community.qlik.com/t5/QlikView/Help-needed-with-Max-Date-trigger/m-p/1010955#M343038 MK_QSL 2015-11-30T19:15:19Z Re: Help needed with Max Date trigger https://community.qlik.com/t5/QlikView/Help-needed-with-Max-Date-trigger/m-p/1010956#M343039 <HTML><HEAD></HEAD><BODY><P>Thanks Manish. How do I implement it on the trigger/selection?</P></BODY></HTML> Mon, 30 Nov 2015 19:44:27 GMT https://community.qlik.com/t5/QlikView/Help-needed-with-Max-Date-trigger/m-p/1010956#M343039 2015-11-30T19:44:27Z Re: Help needed with Max Date trigger https://community.qlik.com/t5/QlikView/Help-needed-with-Max-Date-trigger/m-p/1010957#M343040 <HTML><HEAD></HEAD><BODY><P>I tried this and didnt work<IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/107668_Capture.PNG" style="height: 210px; width: 620px;" /></P></BODY></HTML> Mon, 30 Nov 2015 19:50:48 GMT https://community.qlik.com/t5/QlikView/Help-needed-with-Max-Date-trigger/m-p/1010957#M343040 2015-11-30T19:50:48Z Re: Help needed with Max Date trigger https://community.qlik.com/t5/QlikView/Help-needed-with-Max-Date-trigger/m-p/1010958#M343041 <HTML><HEAD></HEAD><BODY><P><IMG alt="ScreenShot458.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/108202_ScreenShot458.jpg" style="height: auto;" /></P></BODY></HTML> Mon, 07 Dec 2015 09:30:24 GMT https://community.qlik.com/t5/QlikView/Help-needed-with-Max-Date-trigger/m-p/1010958#M343041 zarmoton 2015-12-07T09:30:24Z