Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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