topic yes in QlikView https://community.qlik.com/t5/QlikView/yes/m-p/1256784#M625031 <HTML><HEAD></HEAD><BODY><P>yes</P></BODY></HTML> Wed, 16 Nov 2016 04:47:34 GMT Anonymous 2016-11-16T04:47:34Z yes https://community.qlik.com/t5/QlikView/yes/m-p/1256784#M625031 <HTML><HEAD></HEAD><BODY><P>yes</P></BODY></HTML> Wed, 16 Nov 2016 04:47:34 GMT https://community.qlik.com/t5/QlikView/yes/m-p/1256784#M625031 Anonymous 2016-11-16T04:47:34Z Re: How to derive year & Month fields seperately in yearmonth field https://community.qlik.com/t5/QlikView/yes/m-p/1256785#M625032 <HTML><HEAD></HEAD><BODY><P>Try with this way</P><P></P><P>Noconcatenate</P><P>Load</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">*,<BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Right(YeraMonth,4) as Year </SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Left(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">YeraMonth,3) as Month</SPAN></SPAN></P><P><SPAN style="color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Resident Source;</SPAN></P><P><SPAN style="color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Drop table Source;</SPAN></P><P><SPAN style="color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Regards</SPAN></P><P><SPAN style="color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Anand<BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P></BODY></HTML> Wed, 16 Nov 2016 04:55:01 GMT https://community.qlik.com/t5/QlikView/yes/m-p/1256785#M625032 its_anandrjs 2016-11-16T04:55:01Z Re: How to derive year & Month fields seperately in yearmonth field https://community.qlik.com/t5/QlikView/yes/m-p/1256786#M625033 <HTML><HEAD></HEAD><BODY><P>Try like:</P><P></P><P>Load</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Year(Date#(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">YeraMonth, 'MMMYYYY'</SPAN>)) as Year,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">Month(Date#(</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">YeraMonth, 'MMMYYYY'</SPAN><SPAN style="font-size: 13.3333px;">)) as Month</SPAN></P><P></P><P>Edit: Added a missing 'Y' in the format</P></BODY></HTML> Wed, 16 Nov 2016 04:55:20 GMT https://community.qlik.com/t5/QlikView/yes/m-p/1256786#M625033 tresB 2016-11-16T04:55:20Z Re: How to derive year & Month fields seperately in yearmonth field https://community.qlik.com/t5/QlikView/yes/m-p/1256787#M625034 <HTML><HEAD></HEAD><BODY><P>This way, Month would be a text field and we should avoid that.</P></BODY></HTML> Wed, 16 Nov 2016 04:56:42 GMT https://community.qlik.com/t5/QlikView/yes/m-p/1256787#M625034 tresB 2016-11-16T04:56:42Z