topic Re: After adding script on reduce the file size , how to know it will not affect the report ? in QlikView

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

paulyeo11 — Wed, 28 Jun 2017 07:43:58 GMT

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

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

prma7799 — Wed, 28 Jun 2017 07:48:38 GMT

You can create copy of your original file and do the changes in copy file you will get changed or side effect.

For target could you please share some sample data with us.

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

paulyeo11 — Wed, 28 Jun 2017 08:25:52 GMT

Hi PM

If you manually select Year_n = 1 2 and 3 , the target data become zero.

Paul Yeo

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

prma7799 — Wed, 28 Jun 2017 09:09:52 GMT

Failed to open this document

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

Kushal_Chawda — Wed, 28 Jun 2017 09:12:48 GMT

You can exclude the year_n selection, if you don't want

money(

SUM({<Year_n, year = {'$(=Max(year))'}, month = {"<=$(=IF(GetSelectedCount(month), Max({<year = {'$(=Max(year))'}>}month), Num(Month(Today()))))"}>}sales_target/1000)

, $(vMoneyFormatK))

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

paulyeo11 — Wed, 28 Jun 2017 09:22:09 GMT

I have try your expression , but it return zero.

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

Kushal_Chawda — Wed, 28 Jun 2017 09:25:22 GMT

try this

money(

SUM({<Year_n, year = {'$(=Max(year))'}, month = {"<=$(=IF(GetSelectedCount(month), Max({<year = {'$(=Max(year))'}>}month), Num(Month(Today()))))"}>}sales_target/$(Columndim89)/1000)

, $(vMoneyFormatK))

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

paulyeo11 — Wed, 28 Jun 2017 09:27:12 GMT

Still not working.

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

Kushal_Chawda — Wed, 28 Jun 2017 09:30:32 GMT

It's working in my application

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

Kushal_Chawda — Wed, 28 Jun 2017 09:32:37 GMT

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

paulyeo11 — Wed, 28 Jun 2017 10:29:38 GMT

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>

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

Kushal_Chawda — Wed, 28 Jun 2017 11:40:59 GMT

Please close the thread by marking correct answer

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

paulyeo11 — Mon, 03 Jul 2017 06:03:26 GMT

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

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

paulyeo11 — Wed, 05 Jul 2017 02:14:50 GMT

Hi Kushal

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

Paul Yeo