Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Using both WHILE and WHERE statement in a LOAD

Upon loading the DataTable from a temporary table I'd like to accomplish two things:

1. Add dates from a date range

2. Clean up the rawdata by deleting empty records and subtotals

I've added a WHILE-statement to add the dates (point 1).

But I can't figure out how to combine the WHILE-statement with a WHERE-statement.

I've added an example-file to show in more detail what I'm looking for.

Does anyone know how to combine the WHILE and WHERE Statement?

1 Solution

Accepted Solutions
MVP
MVP

Re: Using both WHILE and WHERE statement in a LOAD

May be like this? PFA.

Edit: Corrected the app, please find the new one.

1 Reply
MVP
MVP

Re: Using both WHILE and WHERE statement in a LOAD

May be like this? PFA.

Edit: Corrected the app, please find the new one.

Community Browser