topic Re: Limit the x-axis date values in QlikView https://community.qlik.com/t5/QlikView/Limit-the-x-axis-date-values/m-p/562239#M554705 <HTML><HEAD></HEAD><BODY><P>here is the trick.</P><P></P><P></P><P>go to your dimensions and click on + sign..</P><P></P><P>click on text color..</P><P></P><P>there you can define condition like this:</P><P></P><P>=if(month='jan' or month='march',red(),White())</P><P></P><P>HTH</P><P>sushil</P></BODY></HTML> Tue, 06 Aug 2013 18:06:34 GMT sushil353 2013-08-06T18:06:34Z Limit the x-axis date values https://community.qlik.com/t5/QlikView/Limit-the-x-axis-date-values/m-p/562238#M554704 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a line chart with date (MM/DD/YY) as x-axis dimension.</P><P>we have data for current 12 months, it shows all 12 months in the chart, but i want to show only 6 months from that as a label in x-axis but it should show 12 months data in the chart (alternate Month dates should be shown in the chart).</P><P>How we can achieve it?</P></BODY></HTML> Tue, 06 Aug 2013 14:49:48 GMT https://community.qlik.com/t5/QlikView/Limit-the-x-axis-date-values/m-p/562238#M554704 2013-08-06T14:49:48Z Re: Limit the x-axis date values https://community.qlik.com/t5/QlikView/Limit-the-x-axis-date-values/m-p/562239#M554705 <HTML><HEAD></HEAD><BODY><P>here is the trick.</P><P></P><P></P><P>go to your dimensions and click on + sign..</P><P></P><P>click on text color..</P><P></P><P>there you can define condition like this:</P><P></P><P>=if(month='jan' or month='march',red(),White())</P><P></P><P>HTH</P><P>sushil</P></BODY></HTML> Tue, 06 Aug 2013 18:06:34 GMT https://community.qlik.com/t5/QlikView/Limit-the-x-axis-date-values/m-p/562239#M554705 sushil353 2013-08-06T18:06:34Z