filter results in load statement

[#1]

Hi, I'm new to Qlik, I am trying to filter out order type to only those coded as "O"

Seems logical to me that I could simply place in the load

"ord_type"='O'

But this does not seem to work, my results are pulling in O and Q type orders

I also tried "ord_type" like 'O'

Still no go

[jonathandienst]

I would put the Where clause in he SQL statement, otherwise you are fetching the O's and Q's from the database over the network and into your QV server, and then discarding them.

SQL SELECT *

FROM "100".dbo."oeordhdr_sql"

Where ord_type = 'O';

[#3]

Perfect, that's what I was originally trying to do, but didn't know where to put the statement. Makes perfect sense.