topic Re: How to further reduce my QV sample Doc ? in QlikView

How to further reduce my QV sample Doc ?

paulyeo11 — Wed, 17 Feb 2016 01:56:07 GMT

Hi All

Binary "C:\Users\Paul Yeo\Dropbox\0_Q_Development\0 Q_QVD\000_QVD_v2116s.qvw";

NEW:

NOCONCATENATE

LOAD *

RESIDENT MasterCalendar WHERE year>'2013';

DROP TABLES MasterCalendar ;

I am using above script to load the QV Doc. I notice that the reduction is not much.

My question is it there any other way that i can do to reduce the file size ?

Paul

Re: How to further reduce my QV sample Doc ?

jagan — Wed, 17 Feb 2016 02:07:20 GMT

Hi,

You are just reducing the size of Master Calendar not actual data, do this in your transaction table

NEW:

NOCONCATENATE

LOAD *

RESIDENT Transaction WHERE year>'2013';

DROP TABLES Transaction ;

Hope this helps you.

Regards,

Jagan.

Re: How to further reduce my QV sample Doc ?

jagan — Wed, 17 Feb 2016 02:08:39 GMT

One more method is open your qlikview file

Select all years greater than 2013 and

File Menu -> Reduce Data -> Keep Possible values and save the file.

This will also do the same, but there is no need to reload your qlikview file.

Regards,

Jagan.

Re: How to further reduce my QV sample Doc ?

paulyeo11 — Wed, 17 Feb 2016 03:48:31 GMT

Hi Jagan

Thank you very much. Look like there are limit i can reduce.

Paul

Re: How to further reduce my QV sample Doc ?

paulyeo11 — Wed, 17 Feb 2016 16:25:48 GMT

Hi Jagan

I just try to select only 2016 data and i follow your step in doing the data reduction , i notice that my QV Doc now only 2.6 Mb.

Thank you for your sharing.

Paul

Re: How to further reduce my QV sample Doc ?

jagan — Thu, 18 Feb 2016 00:32:05 GMT

Yes, even you can select other filters in addition to Year and then reduce. It will reduce based on current selections.

Regards,

Jagan.

Re: How to further reduce my QV sample Doc ?

paulyeo11 — Thu, 18 Feb 2016 01:51:21 GMT

Hi Jagan

This is what I want and can reduce quite a lot data. Thank sweuhl for make my QV sample file reduce , this also make my upload easy and most impt make other easy too.

Paul

Sent from my iPhone