Discussion Board for collaboration on QlikView Scripting.
When I select data from an ODBC-source, I can limit the selected data with the WHERE-clause.
where DATE > '01.01.2006';
I'd like to know the equivalent, if I LOAD data from a .qvd-file and only want to load data which match the given criteria, i.e. only one specific customer-ID. The WHERE-clause doesn't work in combination with LOAD, afaik.
I bet this is a simple thing but I didn't figure it out yet.
Solved! Go to Solution.
where LABELNR = 33271;
make sure the field LABRLNR is number.
if it is string u need to use LABELNR='33271'
I tried both before. As I said: problem seems to be that QV does interpret the where-statement as part of the filepath (see the error message screenshot).
I do not use a directory-statement to ensure that QV uses relative paths instead of absolutes. This works everywhere in the script but it seems as if it does not in this special case.
Error opening file 'D:\Workarea\QVDs\Struktur\ARTIKEL.qvd where LABELNR = 33273' etc.
You can see at the quote signs that QV thinks of the whole expression as filename...
have u used :
if yes......and it didn't work.....just delete ur script and use the 'Table files' button to select from ur qvd after checking the box 'Relative paths' and just remove the semi colon after the statememt generated and put the where clause.