QVW how to limit load ?

[paulyeo11]

Hi All

I just notice that QS can be limited load data thru below link with the help from Andy  :-

QS how to reduce the data ?

Now i like to learn how to limit load in QV QVW file.

For above link , it is QS which load binary file of QVD.QVW file into QS, which is successfully limit load data , and now i want to try limit load in QV ( not in QS ) , so what i did is  i open my QVD.QVW file and i paste the below script to My QVW file :-

NewFilteredTable:

NOCONCATENATE

LOAD *

RESIDENT sales WHERE BRAND_='BECKHOFF';

DROP TABLES sales;

But i get error :-

[Gysbert_Wassenaar · Accepted solution]

The error Table not found means that there is no table with the name 'sales' at the moment that that part of the script is executed. Perhaps you misspelled the name of the source table. Qlikview is case sensitive. So sales, Sales and SALES are three different names to Qlikview.

[paulyeo11]

Hi Gysbert

Thank you very much , yes you are right , i mistaken sales_table as sales.

Now working fine.

Paul