Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

what is the best way to reduce the file size ?

Hi All

I have QVW file , i like to reduce the file size .

what i did is i remove the old data. That is my sales order table have sales from 1997 till 2017.

So what i do is to remove the 1997 till 2013 data. as those old data we don;t need to analyse.

NewFilteredTable:

NOCONCATENATE

LOAD *

RESIDENT sales WHERE

//BRAND_='BECKHOFF';

  Year_n < 4;

DROP TABLES sales;

When i using the above script to remove those old data only keep last 4 year data.

Year_n = 1 is current sales

Year_n = 2 is last year sales


Above work fine , but it affect my sales target report.


Can some one advise me how to reduce the file size and not affect my report ?

Paul Yeo

11 Replies
paulyeo11
Master
Master
Author

Hi Kushal

The link you give me on doc analysis. i think it is good tool.

I just try i get some error.

I will post my question on there.

Paul Yeo

paulyeo11
Master
Master
Author

Hi Kushal

Document Analyzer V3.0 Update Available

I have post the error msg on the above link.

As i still unable to use the Doc Analyzer.

Paul