topic Re: monthnumber in QlikView https://community.qlik.com/t5/QlikView/monthnumber/m-p/1449524#M802786 <HTML><HEAD></HEAD><BODY><P>Why don't you use the LDDate in the expression instead like: </P><P>=num(month(max(<STRONG>LDDate</STRONG>)))</P></BODY></HTML> Fri, 10 Nov 2017 07:04:55 GMT tresB 2017-11-10T07:04:55Z monthnumber https://community.qlik.com/t5/QlikView/monthnumber/m-p/1449523#M802784 <HTML><HEAD></HEAD><BODY><P>PLease find the atachment of the QW file ..</P><P></P><P></P><P>Epertise please do suggest</P><P></P><P></P><P>Thanks in advance</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/monthnumber/m-p/1449523#M802784 smilingjohn 2020-11-25T16:16:04Z Re: monthnumber https://community.qlik.com/t5/QlikView/monthnumber/m-p/1449524#M802786 <HTML><HEAD></HEAD><BODY><P>Why don't you use the LDDate in the expression instead like: </P><P>=num(month(max(<STRONG>LDDate</STRONG>)))</P></BODY></HTML> Fri, 10 Nov 2017 07:04:55 GMT https://community.qlik.com/t5/QlikView/monthnumber/m-p/1449524#M802786 tresB 2017-11-10T07:04:55Z Re: monthnumber https://community.qlik.com/t5/QlikView/monthnumber/m-p/1449525#M802787 <HTML><HEAD></HEAD><BODY><P>Try to change</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;"><STRONG style="font-size: 10pt;">SET</STRONG></SPAN><SPAN style="font-size: 10pt;"> <STRONG><EM style=": ; color: #808080;">DateFormat</EM></STRONG>='DD-MM-YYYY'; </SPAN></P><P><SPAN style="font-size: 10pt;">to</SPAN></P><P><SPAN style="font-size: 10pt;"><SPAN style="color: #0000ff; font-size: 8pt;"><STRONG style="font-size: 10pt;">SET</STRONG></SPAN><SPAN style="font-size: 10pt;"> <STRONG><EM style=": ; color: #808080;">DateFormat</EM></STRONG>='MM-DD-YYYY';</SPAN></SPAN></P><P><SPAN style="font-size: 10pt;">in Script.</SPAN></P><P></P></BODY></HTML> Fri, 10 Nov 2017 07:13:38 GMT https://community.qlik.com/t5/QlikView/monthnumber/m-p/1449525#M802787 antoniotiman 2017-11-10T07:13:38Z Re: monthnumber https://community.qlik.com/t5/QlikView/monthnumber/m-p/1449526#M802789 <HTML><HEAD></HEAD><BODY><P>Why are you using Created date?</P><P></P><P>Please use this =num(month(max(LDDate)))</P></BODY></HTML> Fri, 10 Nov 2017 07:14:03 GMT https://community.qlik.com/t5/QlikView/monthnumber/m-p/1449526#M802789 prat1507 2017-11-10T07:14:03Z