Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

paulyeo11
Valued Contributor II

QVW how to limit load ?

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

linmit load.png

1 Solution

Accepted Solutions

Re: QVW how to limit load ?

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.


talk is cheap, supply exceeds demand
2 Replies

Re: QVW how to limit load ?

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.


talk is cheap, supply exceeds demand
paulyeo11
Valued Contributor II

Re: QVW how to limit load ?

Hi Gysbert

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

Now working fine.

Paul