Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

After adding script on reduce the file size , how to know it will not affect the report ?

Hi All

Recently i want to make my QVW file size below 25 Mb. So i add below script into my QVW file. it work fine and can reduce the file size to what i want.

NewFilteredTable:

NOCONCATENATE

LOAD *

RESIDENT sales WHERE

  Year_n < 4

DROP TABLES sales;

But the issue is it affect some of the report on sales vs target , the target amount become zero.

For this case Lucky for me i only make one changes. and since the target amount all become zero , i know it is due to add above script. Otherwise i will not be able to figure why ?

My question is after adding new script , how to know it will create any side effect ? Or how to prevent this kind of problem from happening again ?

Paul

13 Replies
paulyeo11
Master
Master
Author

Hi KUS

THank you very much .

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804

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

Kushal_Chawda

Please close the thread by marking correct answer

paulyeo11
Master
Master
Author

Hi Kushai

Today i just back from holiday , and i try again your script , it does not work.

it is possible for your post the QVW file here ?

So i know where i go wrong,

Paul

paulyeo11
Master
Master
Author

Hi Kushal

Kindly send me the QVW file which you mentioned is working . As my side still not able to work.

Paul Yeo