How to reduce a file size from year > 2000

[paulyeo11]

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

[paulyeo11]

Hi

I get below error :-

Cannot open file 'C:\Users\Paul Yeo\Dropbox\0_Q_Development\0 Q_QVD\SalesTable'

sales:

Load * From SalesTable

Paul

[paulyeo11]

Hi P M

My table name = sales

I need to make use of load script to filter year > 2000

Paul Yeo

[prma7799]

if your table name is sales

Then simply add where condition

Load * from sales

Where year > 2000;

But i am confused about SalesTable what is that ...

For below error

Cannot open file 'C:\Users\Paul Yeo\Dropbox\0_Q_Development\0 Q_QVD\SalesTable'

You need need to check qvd path .

[stabben23]

Dear friend Paul,

Understand me right here, but after a quick look into Your Qlikview app I have The following conclusion:

If you ever complete this Project there will be life on march.

I'll think you need Professional help from a Qlikview consultant here.

[paulyeo11]

Hi P M

I not yet generate the qvd file .

my sales table name = sales

I mean in my QVW file i file attach above , if you control T , you can see many table , one of the table is sales ( which is sales order table ) .

Paul Yeo

[paulyeo11]

Hi Staffan

Thank you for your advise . I wish I can get Consultants advise.

As I am doing Qlik View is to help me on my personal work , and my company does not provide me Budget for getting consultant advise.

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804

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

[prma7799]

In your sales table there is no year field available what is Year_n ?

[paulyeo11]

Hi P M

You got the point , the year_n 1 is for me to filter current year .

May be I can make use of this field to do the filter.

Since my year filed is at master calendar table.

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804

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

[prma7799]

Yeah you can put condition in where year_n  > 2000

but year_n  is having 1 2 3 4 5 6 values what is that ?

[paulyeo11]

The year_n = 1 , year =2017

So if I want to filter only last 4 year , I just put year_n > 4

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804

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