Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
MelG
Partner - Contributor
Partner - Contributor

Limit QVD size at store

Not truly new to Qlik Sense but new to this requirement.  Is there a way when storing data from a LOAD script into QVDs that you can chunk the data up into equal sized QVDs?  Or is it that you have to engineer the load script to loop through or chunk the data by where clause or number of rows?  Don't want to have something that is maintenance heavy and also need to future proof as data set grows. 

2 Replies
marmentrout5
Contributor
Contributor

Not aware of any functionality to limit size of QVD.  You can loop through the data and store, in a QVD, based on some criteria - date/company/etc.

marcus_sommer

Like you already guessed you will need some extra logic within a loop which sliced the data appropriate. IMO better would be to slice the data into yearly / yearmonth buckets regardless if the filesize is quite equally between the files or not.

- Marcus