Discussion Board for collaboration on QlikView Scripting.
Binary "C:\Users\Paul Yeo\Dropbox\0_Q_Development\0 Q_QVD\000_QVD_v2116s.qvw";
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 ?
Go to Solution.
You are just reducing the size of Master Calendar not actual data, do this in your transaction table
RESIDENT Transaction WHERE year>'2013';
DROP TABLES Transaction ;
Hope this helps you.
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.
Thank you very much. Look like there are limit i can reduce.
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.
Yes, even you can select other filters in addition to Year and then reduce. It will reduce based on current selections.
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.
Sent from my iPhone