topic Re: Need help in script level in QlikView https://community.qlik.com/t5/QlikView/Need-help-in-script-level/m-p/375727#M139999 <HTML><HEAD></HEAD><BODY><P>Is Month1 always the current month, or do you have a year field stored somewhere?</P></BODY></HTML> Mon, 02 Jul 2012 16:36:32 GMT hallquist_nate 2012-07-02T16:36:32Z Need help in script level https://community.qlik.com/t5/QlikView/Need-help-in-script-level/m-p/375723#M139995 <HTML><HEAD></HEAD><BODY><P>Hello Friends,</P><P></P><P>I have a field names in the table like the following.</P><P></P><P>Month1, Month2, Month3, Month4, Month5 etc...</P><P></P><P>My requirement is, is it possilble to rename the column names in the script like display as Jul 2012, Jun 2012 etc....</P><P></P><P><STRONG>Month1&nbsp; as Monthname(today(),-11)</STRONG></P><P><STRONG>Month2 as&nbsp; Monthname(today(),-10)</STRONG></P><P><STRONG>.......... etc..</STRONG></P><P></P><P>Regards</P><P></P><P>Chriss</P><P><STRONG><BR /></STRONG></P></BODY></HTML> Mon, 02 Jul 2012 12:05:25 GMT https://community.qlik.com/t5/QlikView/Need-help-in-script-level/m-p/375723#M139995 2012-07-02T12:05:25Z Re: Need help in script level https://community.qlik.com/t5/QlikView/Need-help-in-script-level/m-p/375724#M139996 <HTML><HEAD></HEAD><BODY><P>please see attached for a possible solution</P></BODY></HTML> Mon, 02 Jul 2012 12:17:08 GMT https://community.qlik.com/t5/QlikView/Need-help-in-script-level/m-p/375724#M139996 giakoum 2012-07-02T12:17:08Z Re: Need help in script level https://community.qlik.com/t5/QlikView/Need-help-in-script-level/m-p/375725#M139997 <HTML><HEAD></HEAD><BODY><P>Have you tried using the Cross Table function in the File Wizard?&nbsp; That is another option, as it appears that is how your data is structured.</P></BODY></HTML> Mon, 02 Jul 2012 12:40:23 GMT https://community.qlik.com/t5/QlikView/Need-help-in-script-level/m-p/375725#M139997 hallquist_nate 2012-07-02T12:40:23Z Re: Need help in script level https://community.qlik.com/t5/QlikView/Need-help-in-script-level/m-p/375726#M139998 <HTML><HEAD></HEAD><BODY><P>Dear Loannis and Nate </P><P></P><P>Thanks for your reply but I can not relate the month name, the ultimate aim is need to draw line chart that will show the month name and sum of&nbsp; (KPMN01).</P><P></P><P>I have attached the work file.</P><P></P><P>could you please give a idea how to proceed....</P><P></P><P>Regards</P><P></P><P>Chriss</P></BODY></HTML> Mon, 02 Jul 2012 13:27:27 GMT https://community.qlik.com/t5/QlikView/Need-help-in-script-level/m-p/375726#M139998 2012-07-02T13:27:27Z Re: Need help in script level https://community.qlik.com/t5/QlikView/Need-help-in-script-level/m-p/375727#M139999 <HTML><HEAD></HEAD><BODY><P>Is Month1 always the current month, or do you have a year field stored somewhere?</P></BODY></HTML> Mon, 02 Jul 2012 16:36:32 GMT https://community.qlik.com/t5/QlikView/Need-help-in-script-level/m-p/375727#M139999 hallquist_nate 2012-07-02T16:36:32Z Re: Need help in script level https://community.qlik.com/t5/QlikView/Need-help-in-script-level/m-p/375728#M140000 <HTML><HEAD></HEAD><BODY><P>The work file was not attached. Please retry!</P></BODY></HTML> Mon, 02 Jul 2012 16:59:07 GMT https://community.qlik.com/t5/QlikView/Need-help-in-script-level/m-p/375728#M140000 giakoum 2012-07-02T16:59:07Z Re: Need help in script level https://community.qlik.com/t5/QlikView/Need-help-in-script-level/m-p/375729#M140001 <HTML><HEAD></HEAD><BODY><P>Sorry Loannis,</P><P></P><P>Yesterday net is down not able to attach the file.. please find the attached</P><P></P><P>Regards</P><P></P><P>Chriss</P></BODY></HTML> Tue, 03 Jul 2012 07:00:09 GMT https://community.qlik.com/t5/QlikView/Need-help-in-script-level/m-p/375729#M140001 2012-07-03T07:00:09Z