topic Re: Graph trendline in QlikView

topic Re: Graph trendline in QlikView https://community.qlik.com/t5/QlikView/Graph-trendline/m-p/453238#M559256 <HTML><HEAD></HEAD><BODY><P>I use year and month. Date formant yyy-mm-dd. I promoted year above month - does not make a difference.</P></BODY></HTML> Mon, 13 May 2013 13:52:34 GMT 2013-05-13T13:52:34Z Graph trendline https://community.qlik.com/t5/QlikView/Graph-trendline/m-p/453232#M559250 <HTML><HEAD></HEAD><BODY><P>Hi - I'm new to Qlickview and got stuck on X Axis - I have data spanning from 2012/10 to 2013/04. When I select the year i.e. 2012 and 2103, the  'Month' display on the X Axis display  2013 Jan - April first, then 2012 Oct - Nov.</P><P></P><P>Any suggestions Please.</P><P></P><P>Regards</P><P></P><P>Fanie</P></BODY></HTML> Mon, 13 May 2013 13:41:52 GMT https://community.qlik.com/t5/QlikView/Graph-trendline/m-p/453232#M559250 2013-05-13T13:41:52Z Re: Graph trendline https://community.qlik.com/t5/QlikView/Graph-trendline/m-p/453233#M559251 <HTML><HEAD></HEAD><BODY><P>Are you using 2 dimensions, Month and Year or 1 dimension MonthYear?</P></BODY></HTML> Mon, 13 May 2013 13:46:42 GMT https://community.qlik.com/t5/QlikView/Graph-trendline/m-p/453233#M559251 jpapador 2013-05-13T13:46:42Z Re: Graph trendline https://community.qlik.com/t5/QlikView/Graph-trendline/m-p/453234#M559252 <HTML><HEAD></HEAD><BODY><P>I use year and month. Date formant yyy-mm-dd. I promoted year above month - does not make a difference.</P></BODY></HTML> Mon, 13 May 2013 13:49:57 GMT https://community.qlik.com/t5/QlikView/Graph-trendline/m-p/453234#M559252 2013-05-13T13:49:57Z Re: Graph trendline https://community.qlik.com/t5/QlikView/Graph-trendline/m-p/453235#M559253 <HTML><HEAD></HEAD><BODY><P>I use year and month. Date formant yyy-mm-dd. I promoted year above month - does not make a difference.</P></BODY></HTML> Mon, 13 May 2013 13:50:23 GMT https://community.qlik.com/t5/QlikView/Graph-trendline/m-p/453235#M559253 2013-05-13T13:50:23Z Re: Graph trendline https://community.qlik.com/t5/QlikView/Graph-trendline/m-p/453236#M559254 <HTML><HEAD></HEAD><BODY><P>I use year and month. Date formant yyy-mm-dd. I promoted year above month - does not make a difference.</P></BODY></HTML> Mon, 13 May 2013 13:50:36 GMT https://community.qlik.com/t5/QlikView/Graph-trendline/m-p/453236#M559254 2013-05-13T13:50:36Z Re: Graph trendline https://community.qlik.com/t5/QlikView/Graph-trendline/m-p/453237#M559255 <HTML><HEAD></HEAD><BODY><P>I use year and month. Date formant yyy-mm-dd. I promoted year above month - does not make a difference.</P></BODY></HTML> Mon, 13 May 2013 13:50:42 GMT https://community.qlik.com/t5/QlikView/Graph-trendline/m-p/453237#M559255 2013-05-13T13:50:42Z Re: Graph trendline https://community.qlik.com/t5/QlikView/Graph-trendline/m-p/453238#M559256 <HTML><HEAD></HEAD><BODY><P>I use year and month. Date formant yyy-mm-dd. I promoted year above month - does not make a difference.</P></BODY></HTML> Mon, 13 May 2013 13:52:34 GMT https://community.qlik.com/t5/QlikView/Graph-trendline/m-p/453238#M559256 2013-05-13T13:52:34Z Re: Graph trendline https://community.qlik.com/t5/QlikView/Graph-trendline/m-p/453239#M559257 <HTML><HEAD></HEAD><BODY><P>I use year and month. Date formant yyy-mm-dd. I promoted year above month - does not make a difference.</P></BODY></HTML> Mon, 13 May 2013 13:52:46 GMT https://community.qlik.com/t5/QlikView/Graph-trendline/m-p/453239#M559257 2013-05-13T13:52:46Z Re: Graph trendline https://community.qlik.com/t5/QlikView/Graph-trendline/m-p/453240#M559258 <HTML><HEAD></HEAD><BODY><P>Try making a MonthYear field instead of using Month and Year.  In the script it would look like </P><P></P><P>Date(MonthStart(<SPAN style="text-decoration: underline;"><STRONG>Date</STRONG></SPAN>), 'MMMYYYY') as MonthYear </P><P></P><P>Where the bolded and underlined DATE is where you put your date field.  If you could attach an example of your QVW that would be helpful.  If you put Month above year it should list the months on the bottom and a unique line for each year.  </P></BODY></HTML> Mon, 13 May 2013 13:56:27 GMT https://community.qlik.com/t5/QlikView/Graph-trendline/m-p/453240#M559258 jpapador 2013-05-13T13:56:27Z Re: Graph trendline https://community.qlik.com/t5/QlikView/Graph-trendline/m-p/453241#M559259 <HTML><HEAD></HEAD><BODY><P>Works  like a dream - thank you. </P></BODY></HTML> Mon, 13 May 2013 14:03:38 GMT https://community.qlik.com/t5/QlikView/Graph-trendline/m-p/453241#M559259 2013-05-13T14:03:38Z Re: Graph trendline https://community.qlik.com/t5/QlikView/Graph-trendline/m-p/453242#M559260 <HTML><HEAD></HEAD><BODY><P>Any idea how to change the font size and layout of text on the X Axis. I got all but that one?</P></BODY></HTML> Mon, 13 May 2013 14:15:49 GMT https://community.qlik.com/t5/QlikView/Graph-trendline/m-p/453242#M559260 2013-05-13T14:15:49Z Re: Graph trendline https://community.qlik.com/t5/QlikView/Graph-trendline/m-p/453243#M559261 <HTML><HEAD></HEAD><BODY><P>On the Axis tab, there is a section called Dimension Axis.  Click the font button.</P><P></P><P></P><P><IMG class="jiveImage" src="https://community.qlik.com/" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Mon, 13 May 2013 14:28:04 GMT https://community.qlik.com/t5/QlikView/Graph-trendline/m-p/453243#M559261 jpapador 2013-05-13T14:28:04Z Re: Graph trendline https://community.qlik.com/t5/QlikView/Graph-trendline/m-p/453244#M559262 <HTML><HEAD></HEAD><BODY><P>thank you</P></BODY></HTML> Mon, 13 May 2013 14:39:11 GMT https://community.qlik.com/t5/QlikView/Graph-trendline/m-p/453244#M559262 2013-05-13T14:39:11Z