Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

paulyeo11
Valued Contributor II

How to reduce a file size from year > 2000

Hi All

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.

Paul Yeo

1 Solution

Accepted Solutions
prma7799
Honored Contributor III

Re: How to reduce a file size from year > 2000

Hi Paul ,

Sorry for mistake you can use below code for using binary load

Load

*

Resident sales

where year_n > 4

27 Replies
paulyeo11
Valued Contributor II

Re: How to reduce a file size from year > 2000

enclosed my QVW

Re: How to reduce a file size from year > 2000

May be use this in your table

SalesTable:

Load * from <Sales Table> Where year > 2000;

paulyeo11
Valued Contributor II

Re: How to reduce a file size from year > 2000

Hi Anil

Thank you very much for your fast reply.

My table is sales , so i change your script to :-

Sales:

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'

Sales:

Load * from <sales> Where year > 2000

Where i go wrong ?

Paul Yeo

Re: How to reduce a file size from year > 2000

check whether this path has the Sales table?

C:\Users\Paul Yeo\Dropbox\0_Q_Development\0 Q_QVD\<sales>

paulyeo11
Valued Contributor II

Re: How to reduce a file size from year > 2000

Hi Anil

The folder you indicate does not have the sales table. Only have QVW file.

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>

Re: How to reduce a file size from year > 2000

But, Where you want to filter? I meant which Table you want to apply where clause?

paulyeo11
Valued Contributor II

Re: How to reduce a file size from year > 2000

I want to add script at end of the QVW file to do the filter.

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>

prma7799
Honored Contributor III

Re: How to reduce a file size from year > 2000

You need to add this filter end of table ..

Like

Load * from

ABC

Where Year > 2000;

Or please mention Table name which you want to filter with year

Re: How to reduce a file size from year > 2000

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

Sales:

Load * From SalesTable;

Left Join (Sales)

Load * From SalesTable Where year > 2000;

Community Browser