Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

paulyeo11
Valued Contributor II

How to further reduce my QV sample Doc ?

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

1 Solution

Accepted Solutions
MVP
MVP

Re: How to further reduce my QV sample Doc ?

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.

6 Replies
MVP
MVP

Re: How to further reduce my QV sample Doc ?

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.

MVP
MVP

Re: How to further reduce my QV sample Doc ?

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.

paulyeo11
Valued Contributor II

Re: How to further reduce my QV sample Doc ?

Hi Jagan

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

Paul

paulyeo11
Valued Contributor II

Re: How to further reduce my QV sample Doc ?

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

MVP
MVP

Re: How to further reduce my QV sample Doc ?

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

Regards,

Jagan.

paulyeo11
Valued Contributor II

Re: How to further reduce my QV sample Doc ?

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

Community Browser