topic Re: QVW how to limit load ? in App Development

QVW how to limit load ?

paulyeo11 — Sat, 05 Sep 2015 03:29:19 GMT

Hi All

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

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 :-

Re: QVW how to limit load ?

Gysbert_Wassenaar — Sat, 05 Sep 2015 07:52:30 GMT

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.

Re: QVW how to limit load ?

paulyeo11 — Sat, 05 Sep 2015 08:55:54 GMT

Hi Gysbert

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

Now working fine.

Paul