topic Last 12 months in a Line Chart based on Month Number in App Development https://community.qlik.com/t5/App-Development/Last-12-months-in-a-Line-Chart-based-on-Month-Number/m-p/1448354#M35290 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P></P><P>I've had a search of the forum but couldn't find any answers that worked for me.</P><P></P><P>I'm using QlikSense and I'm simply looking to create a Line Chart which shows monthly sales for the current month (max(MonthNo) and the previous 11 months sales shown as different points on the graph.</P><P></P><P>Any help would be much appreciated.</P><P></P><P>Cheers</P><P></P><P>Paul</P></BODY></HTML> Fri, 13 Oct 2017 10:18:17 GMT 2017-10-13T10:18:17Z Last 12 months in a Line Chart based on Month Number https://community.qlik.com/t5/App-Development/Last-12-months-in-a-Line-Chart-based-on-Month-Number/m-p/1448354#M35290 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P></P><P>I've had a search of the forum but couldn't find any answers that worked for me.</P><P></P><P>I'm using QlikSense and I'm simply looking to create a Line Chart which shows monthly sales for the current month (max(MonthNo) and the previous 11 months sales shown as different points on the graph.</P><P></P><P>Any help would be much appreciated.</P><P></P><P>Cheers</P><P></P><P>Paul</P></BODY></HTML> Fri, 13 Oct 2017 10:18:17 GMT https://community.qlik.com/t5/App-Development/Last-12-months-in-a-Line-Chart-based-on-Month-Number/m-p/1448354#M35290 2017-10-13T10:18:17Z Re: Last 12 months in a Line Chart based on Month Number https://community.qlik.com/t5/App-Development/Last-12-months-in-a-Line-Chart-based-on-Month-Number/m-p/1448355#M35291 <HTML><HEAD></HEAD><BODY><P>All you need is set analysis on your monthyear or date field... check here</P><P><A href="https://community.qlik.com/qlik-blogpost/4394">Dates in Set Analysis</A></P></BODY></HTML> Fri, 13 Oct 2017 11:54:26 GMT https://community.qlik.com/t5/App-Development/Last-12-months-in-a-Line-Chart-based-on-Month-Number/m-p/1448355#M35291 sunny_talwar 2017-10-13T11:54:26Z