topic Re: Clarification in QlikView https://community.qlik.com/t5/QlikView/Clarification/m-p/428852#M159845 <HTML><HEAD></HEAD><BODY><P>Hello Gysbert,</P><P></P><P>thanks a lot for your explnation.</P></BODY></HTML> Wed, 12 Dec 2012 10:07:32 GMT 2012-12-12T10:07:32Z Clarification https://community.qlik.com/t5/QlikView/Clarification/m-p/428850#M159843 <HTML><HEAD></HEAD><BODY><P>Hello Friends,</P><P></P><P>Date(MonthName(Period-14,+1),'YYYYMM') as [Trans Period]</P><P></P><P>I am not able understand the above line, could you please explain me, what is it mean of -14.</P><P></P><P>Regards</P><P></P><P>Chriss</P></BODY></HTML> Wed, 12 Dec 2012 07:48:33 GMT https://community.qlik.com/t5/QlikView/Clarification/m-p/428850#M159843 2012-12-12T07:48:33Z Re: Clarification https://community.qlik.com/t5/QlikView/Clarification/m-p/428851#M159844 <HTML><HEAD></HEAD><BODY><P>Period seems to be a date field. Period-14 is then 14 days earlier than the value of Period (i.e. two weeks earlier). Monthname returns the first day of the month of the date, in this case of Period-14. The second parameter 1 is an offset, so it doesn't return the month of Period-14, but a month later. Then this date is formatted using the Date function so it displays in YYYYMM format (e.g. 201204).</P></BODY></HTML> Wed, 12 Dec 2012 09:09:09 GMT https://community.qlik.com/t5/QlikView/Clarification/m-p/428851#M159844 Gysbert_Wassenaar 2012-12-12T09:09:09Z Re: Clarification https://community.qlik.com/t5/QlikView/Clarification/m-p/428852#M159845 <HTML><HEAD></HEAD><BODY><P>Hello Gysbert,</P><P></P><P>thanks a lot for your explnation.</P></BODY></HTML> Wed, 12 Dec 2012 10:07:32 GMT https://community.qlik.com/t5/QlikView/Clarification/m-p/428852#M159845 2012-12-12T10:07:32Z