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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
paulwalker
Creator III
Creator III

Optimization QVD's

Hi Experts,

I have one question for optimization level..

Database team has created one table for 50 countries data. (should I create single QVD or country wise QVD's)

and I have many aggregate tables apply to main table.

which one is the best practice ?

 

1 Reply
zwilson_borg
Contributor III
Contributor III

I tend to work QVDs that match my end data model so that 1 QVD matches 1 table. If you're planning to load all the countries every time you load your dashboards, then a single QVD makes sense.

Subsetting makes more sense if you're sharing QVD across many dashboards, and each dashboard typically needs a subset. In this scenario, you'd rather not load the entire set and then filter down, but rather load the subset.