topic Query Question in QlikView https://community.qlik.com/t5/QlikView/Query-Question/m-p/430849#M700396 <HTML><HEAD></HEAD><BODY><P>I have a SQL Server table that contains sales data by fiscal week number but not all weeks have sales. However, I need a chart that displays all weeks. How can I write my script so that it will load the data rows I do have and create rows for the data I'm missing?</P><P></P><P><IMG __jive_id="25046" class="jive-image" alt="QueryData.jpg" src="https://community.qlik.com/legacyfs/online/25046_QueryData.jpg" /></P></BODY></HTML> Tue, 13 Nov 2012 23:47:57 GMT Anonymous 2012-11-13T23:47:57Z Query Question https://community.qlik.com/t5/QlikView/Query-Question/m-p/430849#M700396 <HTML><HEAD></HEAD><BODY><P>I have a SQL Server table that contains sales data by fiscal week number but not all weeks have sales. However, I need a chart that displays all weeks. How can I write my script so that it will load the data rows I do have and create rows for the data I'm missing?</P><P></P><P><IMG __jive_id="25046" class="jive-image" alt="QueryData.jpg" src="https://community.qlik.com/legacyfs/online/25046_QueryData.jpg" /></P></BODY></HTML> Tue, 13 Nov 2012 23:47:57 GMT https://community.qlik.com/t5/QlikView/Query-Question/m-p/430849#M700396 Anonymous 2012-11-13T23:47:57Z Re: Query Question https://community.qlik.com/t5/QlikView/Query-Question/m-p/430850#M700397 <HTML><HEAD></HEAD><BODY><P>See attached qvw</P></BODY></HTML> Wed, 14 Nov 2012 09:17:07 GMT https://community.qlik.com/t5/QlikView/Query-Question/m-p/430850#M700397 Gysbert_Wassenaar 2012-11-14T09:17:07Z Re: Query Question https://community.qlik.com/t5/QlikView/Query-Question/m-p/430851#M700398 <HTML><HEAD></HEAD><BODY><P>Thank you Gysbert. That gives me the method I can use as a basis for my larger, more complexe query.</P></BODY></HTML> Wed, 14 Nov 2012 19:37:23 GMT https://community.qlik.com/t5/QlikView/Query-Question/m-p/430851#M700398 Anonymous 2012-11-14T19:37:23Z