Discussion Board for collaboration on QlikView Scripting.
Can anybody confirm whether or not I can use a WHERE clause in an ODBC connection?
I am able to connect to a MS Access Database and return all values as per below:
ODBC CONNECT32 TO [MS Access Database;DBQ=C:\Users\hayetom\Qlikview\Examples\Product.accdb];
SQL SELECT *
However, I only want to return rows Where the Product_Line is either 'VL' or 'AB'. I have tried
FROM `DIM_Prod` WHERE (Product_ID = 'VL' or Product_ID = 'AB');
NOTE: I appreciate that I can bring all the rows in and then limit my selection on the resident Load BUT I want to limit the data that is brought in the qvw to begin with.
Go to Solution.
Try using Product_Line in your Where clause, rather than Product_ID
Try this for your where clause.
where Product_ID in('VL','AB')
Try referring to the field as it appears in the SELECT.
where `Product_ID` in('VL','AB')