Exclude rows from SQL Data with multiple conditions

[CVR]

Hello Qlik Experts,

I am new to Qlik, I am trying to pull the data SQL and store into QVD's. In the preceding load I need to apply certain condition in order to exclude some unnecessary rows and they have some conditions to be excluded. Below is the  example script I'm using to exclude the rows.

LOAD

1,

    2,

    3,

    4,

    5,

    6;

SQL SELECT *

FROM "Number".dbo."Equation"

WHERE not(1='0' and 2='0' and 3='0' and  4='0' and 5='0' and 6 < Date(MonthStart(AddMonths(Today(), -37)), 'YYYY-MM-DD'));

For Column 6(it is a date column) the condition is it should not load data which is 37 months old and this should be recurring.

Just want to know If I am right with my script and please suggest if you any good ideas to do so??

Thanks in Advance

[sunny_talwar]

Why don't you exclude the data in the sql itself? This will help you bring less number of rows from sql itself. If you still want to do it in Load, then you need to put your where statement before Select

LOAD

1,

    2,

    3,

    4,

    5,

    6

WHERE not(1='0' and 2='0' and 3='0' and  4='0' and 5='0' and 6 < Date(MonthStart(AddMonths(Today(), -37)), 'YYYY-MM-DD'));

SQL SELECT *

FROM "Number".dbo."Equation";

[CVR]

Thanks for quick reply Sunny. You are right ,I can exclude the DATA in SQL but unfortunately I am not allowed to do so in our SQL DB. I will reload the QVW with your above script and will let you know the result. Can you also please confirm if the below script is correct?

LOAD

OrderDate,

Quantity

WHERE NOT (OrderDate < Date(MonthStart(AddMonths(Today(), -37)), 'YYYY-MM-DD'))

SQL SELECT *

FROM "Sales".dbo."Product";

Script looks good for me don't know why I am getting an error message (red line)

Thank you

[sunny_talwar · Accepted solution]

You are missing a semi colon

LOAD

OrderDate,

Quantity

WHERE NOT (OrderDate < Date(MonthStart(AddMonths(Today(), -37)), 'YYYY-MM-DD'));

SQL SELECT *

FROM "Sales".dbo."Product";