Discussion Board for collaboration on QlikView Scripting.
I have a QVW file , now the file size is 26 mb , I want to reduce to 20 Mb .
from my data model , i notice that there are many table , i want to focus on sales table ,
So i like to filter my Table = sales , and filter those data year > 2000
Hope some one can share with me the load script.
Go to Solution.
Hi Paul ,
Sorry for mistake you can use below code for using binary load
where year_n > 4
enclosed my QVW
May be use this in your table
Load * from <Sales Table> Where year > 2000;
Thank you very much for your fast reply.
My table is sales , so i change your script to :-
Load * from <sales> Where year > 2000;
I get the below error :-
Cannot open file 'C:\Users\Paul Yeo\Dropbox\0_Q_Development\0 Q_QVD\<sales> Where year > 2000'
Load * from <sales> Where year > 2000
Where i go wrong ?
check whether this path has the Sales table?
C:\Users\Paul Yeo\Dropbox\0_Q_Development\0 Q_QVD\<sales>
The folder you indicate does not have the sales table. Only have QVW file.
TDS Technology (S) P/L
Whatsapp +65 9326 1804
But, Where you want to filter? I meant which Table you want to apply where clause?
I want to add script at end of the QVW file to do the filter.
You need to add this filter end of table ..
Load * from
Where Year > 2000;
Or please mention Table name which you want to filter with year
Can you help us to get tab name which has Sales Table? Then we can connect like
Assume, If you have 20 Tabs. In that 20 tabs the sales table in 13th Tab. In that last we have to add like
Load * From SalesTable;
Left Join (Sales)
Load * From SalesTable Where year > 2000;