Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
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