topic Re: unable to exclude null in date field in App Development https://community.qlik.com/t5/App-Development/unable-to-exclude-null-in-date-field/m-p/1068292#M17385 <HTML><HEAD></HEAD><BODY><P>Please don't clutter this site with duplicate discussions: <A href="https://community.qlik.com/thread/210852">unable to exclude null in date field</A>‌</P><P></P><P>I also don't understand what you're asking. Can you give more details?</P></BODY></HTML> Thu, 24 Mar 2016 16:50:39 GMT Gysbert_Wassenaar 2016-03-24T16:50:39Z unable to exclude null in date field https://community.qlik.com/t5/App-Development/unable-to-exclude-null-in-date-field/m-p/1068291#M17384 <HTML><HEAD></HEAD><BODY><P>Hi Folks,</P><P></P><P>I attached the sample data and required output.</P><P></P><P>when i load the excel sheet data i got the null values..How to exclude the null values..?</P><P></P><P>In x-axis i want to show only latest 12 weeks data that should be like ww1,ww2,ww3,.....ww12. How to take it in week format as given..</P><P></P><P>Open &amp; Close - Excluding Null Values</P><P></P><P>How to show "Open" Values in Left and "Close" Values in Right..</P><P></P><P>Thanks in advance..</P><P></P><P>Regards,</P><P>Venal</P></BODY></HTML> Thu, 24 Mar 2016 16:43:26 GMT https://community.qlik.com/t5/App-Development/unable-to-exclude-null-in-date-field/m-p/1068291#M17384 2016-03-24T16:43:26Z Re: unable to exclude null in date field https://community.qlik.com/t5/App-Development/unable-to-exclude-null-in-date-field/m-p/1068292#M17385 <HTML><HEAD></HEAD><BODY><P>Please don't clutter this site with duplicate discussions: <A href="https://community.qlik.com/thread/210852">unable to exclude null in date field</A>‌</P><P></P><P>I also don't understand what you're asking. Can you give more details?</P></BODY></HTML> Thu, 24 Mar 2016 16:50:39 GMT https://community.qlik.com/t5/App-Development/unable-to-exclude-null-in-date-field/m-p/1068292#M17385 Gysbert_Wassenaar 2016-03-24T16:50:39Z