topic Re: Logic1 in QlikView https://community.qlik.com/t5/QlikView/Logic1/m-p/1442499#M803725 <HTML><HEAD></HEAD><BODY><P>Hi John</P><P></P><P>&nbsp;&nbsp; You may need to use</P><P></P><P>Load max(month(Created)) as Max_Month,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Key</P><P>From your table_name</P><P>group by Key</P><P></P><P>-Jai</P></BODY></HTML> Thu, 09 Nov 2017 07:23:47 GMT Anonymous 2017-11-09T07:23:47Z Logic1 https://community.qlik.com/t5/QlikView/Logic1/m-p/1442498#M803724 <HTML><HEAD></HEAD><BODY><P>Hi Expertise</P><P></P><P>PLease find the attachment of the qvw file .</P><P>I want to create a variable or is there a way to show the count of months for maximum Create field ...</P><P>for exmaple in Create field the data is till NOvemeber 2017.</P><P>therefore the filter should show me&nbsp; 11 ...how do i achieve this ? </P><P>this should be for maximum Create Field only ...</P><P></P><P>Thanks </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Logic1/m-p/1442498#M803724 smilingjohn 2020-11-25T16:16:04Z Re: Logic1 https://community.qlik.com/t5/QlikView/Logic1/m-p/1442499#M803725 <HTML><HEAD></HEAD><BODY><P>Hi John</P><P></P><P>&nbsp;&nbsp; You may need to use</P><P></P><P>Load max(month(Created)) as Max_Month,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Key</P><P>From your table_name</P><P>group by Key</P><P></P><P>-Jai</P></BODY></HTML> Thu, 09 Nov 2017 07:23:47 GMT https://community.qlik.com/t5/QlikView/Logic1/m-p/1442499#M803725 Anonymous 2017-11-09T07:23:47Z Re: Logic1 https://community.qlik.com/t5/QlikView/Logic1/m-p/1442500#M803726 <HTML><HEAD></HEAD><BODY><P>In variable write</P><P>=Month(max(dateFieldName))</P><P></P><P>Regards,</P></BODY></HTML> Thu, 09 Nov 2017 07:26:21 GMT https://community.qlik.com/t5/QlikView/Logic1/m-p/1442500#M803726 PrashantSangle 2017-11-09T07:26:21Z