topic How to extract month from column names? in QlikView https://community.qlik.com/t5/QlikView/How-to-extract-month-from-column-names/m-p/354632#M574679 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I have columns say: Share1, Share 2, Share3 etc. Which I will be giving as dimmension, where my Share1 data should always be 2 months before my current month(June-12). </P><P>Now I want to display this columns in bar chart as date for eg:&nbsp;&nbsp; </P><P></P><P>Share1 as April-12</P><P>Share2 as March-12</P><P>Share3 as Feb-12 and so on......&nbsp; </P><P></P><P>Now if i am moving in July-2012 then my Share1 should be displayed as May-12&nbsp; </P><P></P><P></P><P>Please let me know if anyone has any idea.</P><P></P><P>Thanks in Advance</P><P></P><P></P><P>Regards</P><P>Sagar Gupta</P></BODY></HTML> Fri, 15 Jun 2012 12:21:00 GMT 2012-06-15T12:21:00Z How to extract month from column names? https://community.qlik.com/t5/QlikView/How-to-extract-month-from-column-names/m-p/354632#M574679 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I have columns say: Share1, Share 2, Share3 etc. Which I will be giving as dimmension, where my Share1 data should always be 2 months before my current month(June-12). </P><P>Now I want to display this columns in bar chart as date for eg:&nbsp;&nbsp; </P><P></P><P>Share1 as April-12</P><P>Share2 as March-12</P><P>Share3 as Feb-12 and so on......&nbsp; </P><P></P><P>Now if i am moving in July-2012 then my Share1 should be displayed as May-12&nbsp; </P><P></P><P></P><P>Please let me know if anyone has any idea.</P><P></P><P>Thanks in Advance</P><P></P><P></P><P>Regards</P><P>Sagar Gupta</P></BODY></HTML> Fri, 15 Jun 2012 12:21:00 GMT https://community.qlik.com/t5/QlikView/How-to-extract-month-from-column-names/m-p/354632#M574679 2012-06-15T12:21:00Z