topic Re: How to get latest month from the data set in QlikView https://community.qlik.com/t5/QlikView/How-to-get-latest-month-from-the-data-set/m-p/55484#M773150 <HTML><HEAD></HEAD><BODY><P>Hi Sujeeth, you can try with:</P><P>=Month(Max(Date#(MonthField,'MMM')))</P></BODY></HTML> Sun, 20 May 2018 09:05:47 GMT rubenmarin 2018-05-20T09:05:47Z How to get latest month from the data set https://community.qlik.com/t5/QlikView/How-to-get-latest-month-from-the-data-set/m-p/55477#M773143 <HTML><HEAD></HEAD><BODY><P>I have the data like in the month column</P><P></P><P>Jan</P><P>Feb</P><P>March</P><P>April</P><P>May......</P><P></P><P>Now I want latest month dynamically.</P><P>My Output should be Month= "May"</P><P></P><P>Thank you</P><P>Sujeeth</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-get-latest-month-from-the-data-set/m-p/55477#M773143 Anonymous 2020-11-25T16:16:04Z Re: How to get latest month from the data set https://community.qlik.com/t5/QlikView/How-to-get-latest-month-from-the-data-set/m-p/55478#M773144 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>here is one way to do it:</P><P></P><P>you should have your MonthNames system variable like this:</P><P></P><P>Set MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';</P><P></P><P>max_month:</P><P>LOAD 1 as flag, Date#(month,'MMM') as month, num(month(Date#(month,'MMM'))) as monthnum Inline [</P><P>month</P><P>Jan</P><P>Feb</P><P>Mar</P><P>Apr</P><P>May</P><P>];</P><P></P><P>join</P><P>LOAD max(monthnum) as max_month</P><P>Resident max_month</P><P>Group by flag;</P><P></P><P>final:</P><P>NoConcatenate</P><P>LOAD * Resident max_month</P><P>Where monthnum=max_month;</P><P></P><P>DROP Table max_month;</P><P></P><P>PFA</P></BODY></HTML> Fri, 18 May 2018 13:50:48 GMT https://community.qlik.com/t5/QlikView/How-to-get-latest-month-from-the-data-set/m-p/55478#M773144 YoussefBelloum 2018-05-18T13:50:48Z Re: How to get latest month from the data set https://community.qlik.com/t5/QlikView/How-to-get-latest-month-from-the-data-set/m-p/55479#M773145 <HTML><HEAD></HEAD><BODY><P>LOAD</P><P>MONTH AS LAST MONTH</P><P>FROM YOURQVD</P><P>WHERE MONTH=MONTH(TODAY)</P></BODY></HTML> Fri, 18 May 2018 14:34:28 GMT https://community.qlik.com/t5/QlikView/How-to-get-latest-month-from-the-data-set/m-p/55479#M773145 eduardo_dimperio 2018-05-18T14:34:28Z Re: How to get latest month from the data set https://community.qlik.com/t5/QlikView/How-to-get-latest-month-from-the-data-set/m-p/55480#M773146 <HTML><HEAD></HEAD><BODY><P>your solution works only if you have the actual month in your dataset</P></BODY></HTML> Fri, 18 May 2018 14:58:21 GMT https://community.qlik.com/t5/QlikView/How-to-get-latest-month-from-the-data-set/m-p/55480#M773146 YoussefBelloum 2018-05-18T14:58:21Z Re: How to get latest month from the data set https://community.qlik.com/t5/QlikView/How-to-get-latest-month-from-the-data-set/m-p/55481#M773147 <HTML><HEAD></HEAD><BODY><P>yeap</P></BODY></HTML> Fri, 18 May 2018 17:14:04 GMT https://community.qlik.com/t5/QlikView/How-to-get-latest-month-from-the-data-set/m-p/55481#M773147 eduardo_dimperio 2018-05-18T17:14:04Z Re: How to get latest month from the data set https://community.qlik.com/t5/QlikView/How-to-get-latest-month-from-the-data-set/m-p/55482#M773148 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I did it as below:</P><P></P><P><STRONG style="color: blue; background: white; font-size: 8.0pt; font-family: 'inherit',serif;">LOAD</STRONG><SPAN style="font-size: 8.0pt; font-family: 'Helvetica',sans-serif; color: #3d3d3d; background: white;"> * </SPAN><SPAN style="font-size: 8.0pt; font-family: 'Helvetica',sans-serif; color: blue; background: white;">INLINE</SPAN> <SPAN style="font-size: 8.0pt; font-family: 'Helvetica',sans-serif; color: maroon; background: white;">[<BR /> MonthID, Month<BR /> 1, Jan<BR /> 2, Feb<BR /> 3, Mar<BR /> 4, Apr<BR /> 5, May<BR /> 6, Jun<BR /> 7, Jul<BR /> 8, Aug<BR /> 9, Sep<BR /> 10, Oct<BR /> 11, Nov<BR /> 12, Dec<BR /> ]</SPAN><SPAN style="font-size: 8.0pt; font-family: 'Helvetica',sans-serif; color: #3d3d3d; background: white;">;</SPAN></P><P><SPAN style="font-size: 8.0pt; font-family: 'Helvetica',sans-serif; color: #3d3d3d; background: white;"><BR /></SPAN></P><P><SPAN style="font-size: 8.0pt; font-family: 'Helvetica',sans-serif; color: #3d3d3d; background: white;">Use these formulas:</SPAN></P><P><SPAN style="font-size: 8.0pt; font-family: 'Helvetica',sans-serif; color: #3d3d3d; background: white;"><STRONG>=Max(Month) or</STRONG></SPAN></P><P><SPAN style="font-size: 8.0pt; font-family: 'Helvetica',sans-serif; color: #3d3d3d; background: white;"><STRONG>Month= Month(Today) </STRONG><BR /></SPAN></P></BODY></HTML> Sat, 19 May 2018 04:03:05 GMT https://community.qlik.com/t5/QlikView/How-to-get-latest-month-from-the-data-set/m-p/55482#M773148 Anonymous 2018-05-19T04:03:05Z Re: How to get latest month from the data set https://community.qlik.com/t5/QlikView/How-to-get-latest-month-from-the-data-set/m-p/55483#M773149 <HTML><HEAD></HEAD><BODY><P>Sorting and using peek should be better I guess?</P></BODY></HTML> Sun, 20 May 2018 04:39:41 GMT https://community.qlik.com/t5/QlikView/How-to-get-latest-month-from-the-data-set/m-p/55483#M773149 vkish16161 2018-05-20T04:39:41Z Re: How to get latest month from the data set https://community.qlik.com/t5/QlikView/How-to-get-latest-month-from-the-data-set/m-p/55484#M773150 <HTML><HEAD></HEAD><BODY><P>Hi Sujeeth, you can try with:</P><P>=Month(Max(Date#(MonthField,'MMM')))</P></BODY></HTML> Sun, 20 May 2018 09:05:47 GMT https://community.qlik.com/t5/QlikView/How-to-get-latest-month-from-the-data-set/m-p/55484#M773150 rubenmarin 2018-05-20T09:05:47Z Re: How to get latest month from the data set https://community.qlik.com/t5/QlikView/How-to-get-latest-month-from-the-data-set/m-p/55485#M773151 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>As of now in my excel sheet data contains only March and April data. My requirement is when ever the data loaded to my excel sheet it should take the latest loaded month dynamically.</P><P>Could you please help me on this.</P><P></P><P>Thank you</P><P>Sujeeth</P></BODY></HTML> Mon, 21 May 2018 06:51:56 GMT https://community.qlik.com/t5/QlikView/How-to-get-latest-month-from-the-data-set/m-p/55485#M773151 Anonymous 2018-05-21T06:51:56Z Re: How to get latest month from the data set https://community.qlik.com/t5/QlikView/How-to-get-latest-month-from-the-data-set/m-p/55486#M773152 <HTML><HEAD></HEAD><BODY><P>You can apply something very close to Youssef answer to keep the highest month of data:</P><P></P><P>Set MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';</P><P></P><P>Data:</P><P>LOAD Month(Date#(monthField,'MMM') as month,</P><P>&nbsp; num(month(Date#(monthField,'MMM'))) as monthnum,</P><P> <EM>OtherFields</EM></P><P>FROM [<EM>ExcelFile</EM>];</P><P></P><P>// Inner Join to keep only the max month</P><P>Inner Join (<SPAN style="font-size: 13.3333px;">Data)</SPAN></P><P>LOAD max(monthnum) as <SPAN style="font-size: 13.3333px;">monthnum</SPAN></P><P>Resident <SPAN style="font-size: 13.3333px;">Data</SPAN>;</P></BODY></HTML> Mon, 21 May 2018 07:02:56 GMT https://community.qlik.com/t5/QlikView/How-to-get-latest-month-from-the-data-set/m-p/55486#M773152 rubenmarin 2018-05-21T07:02:56Z Re: How to get latest month from the data set https://community.qlik.com/t5/QlikView/How-to-get-latest-month-from-the-data-set/m-p/55487#M773153 <HTML><HEAD></HEAD><BODY><P>You want to create in variable? or you want to pull only latest month data for whole application. </P></BODY></HTML> Thu, 24 May 2018 03:10:20 GMT https://community.qlik.com/t5/QlikView/How-to-get-latest-month-from-the-data-set/m-p/55487#M773153 Anil_Babu_Samineni 2018-05-24T03:10:20Z