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

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
jagan
Luminary Alumni
Luminary Alumni

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.

View solution in original post

6 Replies
jagan
Luminary Alumni
Luminary Alumni

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.

jagan
Luminary Alumni
Luminary Alumni

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
Master
Master
Author

Hi Jagan

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

Paul

paulyeo11
Master
Master
Author

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

jagan
Luminary Alumni
Luminary Alumni

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

Regards,

Jagan.

paulyeo11
Master
Master
Author

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