topic Using both WHILE and WHERE statement in a LOAD in QlikView https://community.qlik.com/t5/QlikView/Using-both-WHILE-and-WHERE-statement-in-a-LOAD/m-p/508039#M692250 <HTML><HEAD></HEAD><BODY><P>Upon loading the DataTable from a temporary table I'd like to accomplish two things:</P><P>1. Add dates from a date range</P><P>2. Clean up the rawdata by deleting empty records and subtotals</P><P></P><P>I've added a WHILE-statement to add the dates (point 1).</P><P>But I can't figure out how to combine the WHILE-statement with a WHERE-statement.</P><P></P><P>I've added an example-file to show in more detail what I'm looking for.</P><P>Does anyone know how to combine the WHILE and WHERE Statement?</P></BODY></HTML> Wed, 11 Sep 2013 08:35:55 GMT 2013-09-11T08:35:55Z Using both WHILE and WHERE statement in a LOAD https://community.qlik.com/t5/QlikView/Using-both-WHILE-and-WHERE-statement-in-a-LOAD/m-p/508039#M692250 <HTML><HEAD></HEAD><BODY><P>Upon loading the DataTable from a temporary table I'd like to accomplish two things:</P><P>1. Add dates from a date range</P><P>2. Clean up the rawdata by deleting empty records and subtotals</P><P></P><P>I've added a WHILE-statement to add the dates (point 1).</P><P>But I can't figure out how to combine the WHILE-statement with a WHERE-statement.</P><P></P><P>I've added an example-file to show in more detail what I'm looking for.</P><P>Does anyone know how to combine the WHILE and WHERE Statement?</P></BODY></HTML> Wed, 11 Sep 2013 08:35:55 GMT https://community.qlik.com/t5/QlikView/Using-both-WHILE-and-WHERE-statement-in-a-LOAD/m-p/508039#M692250 2013-09-11T08:35:55Z Re: Using both WHILE and WHERE statement in a LOAD https://community.qlik.com/t5/QlikView/Using-both-WHILE-and-WHERE-statement-in-a-LOAD/m-p/508040#M692251 <HTML><HEAD></HEAD><BODY><P>May be like this? PFA.</P><P></P><P>Edit: Corrected the app, please find the new one.</P></BODY></HTML> Wed, 11 Sep 2013 09:11:16 GMT https://community.qlik.com/t5/QlikView/Using-both-WHILE-and-WHERE-statement-in-a-LOAD/m-p/508040#M692251 tresB 2013-09-11T09:11:16Z