topic Removing unmateched dates from charts in QlikView https://community.qlik.com/t5/QlikView/Removing-unmateched-dates-from-charts/m-p/641909#M543532 <HTML><HEAD></HEAD><BODY><P>Newbie here....</P><P></P><P>Plotting a line graph with dates, and the defualt is giving me an extra data on the far right of the x-axis where the data has come back as null. (I've joined a Sales_date to a calendar table).</P><P></P><P>I'd either like to remove these values in the script, or simply hide from the chart.</P><P></P><P>Any help appreciated, thanks in advance.</P><P></P><P><IMG alt="Capture.PNG.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/59331_Capture.PNG.png" /></P></BODY></HTML> Wed, 21 May 2014 15:39:08 GMT 2014-05-21T15:39:08Z Removing unmateched dates from charts https://community.qlik.com/t5/QlikView/Removing-unmateched-dates-from-charts/m-p/641909#M543532 <HTML><HEAD></HEAD><BODY><P>Newbie here....</P><P></P><P>Plotting a line graph with dates, and the defualt is giving me an extra data on the far right of the x-axis where the data has come back as null. (I've joined a Sales_date to a calendar table).</P><P></P><P>I'd either like to remove these values in the script, or simply hide from the chart.</P><P></P><P>Any help appreciated, thanks in advance.</P><P></P><P><IMG alt="Capture.PNG.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/59331_Capture.PNG.png" /></P></BODY></HTML> Wed, 21 May 2014 15:39:08 GMT https://community.qlik.com/t5/QlikView/Removing-unmateched-dates-from-charts/m-p/641909#M543532 2014-05-21T15:39:08Z Re: Removing unmateched dates from charts https://community.qlik.com/t5/QlikView/Removing-unmateched-dates-from-charts/m-p/641910#M543534 <HTML><HEAD></HEAD><BODY><P>in dimesion</P><P></P><P>select date column and check supress null below</P><P></P><P>hope this helps</P></BODY></HTML> Wed, 21 May 2014 15:41:53 GMT https://community.qlik.com/t5/QlikView/Removing-unmateched-dates-from-charts/m-p/641910#M543534 SunilChauhan 2014-05-21T15:41:53Z Re: Removing unmateched dates from charts https://community.qlik.com/t5/QlikView/Removing-unmateched-dates-from-charts/m-p/641911#M543536 <HTML><HEAD></HEAD><BODY><P>Well that was easy!</P><P></P><P>Thanks very much</P></BODY></HTML> Wed, 21 May 2014 15:44:42 GMT https://community.qlik.com/t5/QlikView/Removing-unmateched-dates-from-charts/m-p/641911#M543536 2014-05-21T15:44:42Z Re: Removing unmateched dates from charts https://community.qlik.com/t5/QlikView/Removing-unmateched-dates-from-charts/m-p/641912#M543537 <HTML><HEAD></HEAD><BODY><P>see the attched screen shot</P></BODY></HTML> Wed, 21 May 2014 15:45:03 GMT https://community.qlik.com/t5/QlikView/Removing-unmateched-dates-from-charts/m-p/641912#M543537 SunilChauhan 2014-05-21T15:45:03Z