I have an inventory table that consists of one row per item per day in our warehouse. The number of items is approximately 97k. The time period covered in the inventory table is 3 years. This results in a fact table of about 9.3 million rows. The model I created is correct. All the tables in it are linked by a single column key. As a result, when I try and create a chart object, Qlikview wants to load all 9.3 million rows into the chart. This is not what I had in mind. I don't want the chart process until after an item selection and date range have been chosen. How do I do this?
The previous selections are totally valid, but the way I tend to approach this is to add a counter field to the main fact table (I do this as a matter of course to almost every table):
1 as FactCount,
[... rest of table ...]
You can then use a calculation condition (on the General tab of the properties) of:
=sum(FactCount) <= 100000
This way the chart may render if you have one item picked with no date selection, or a single date selected across all items, or neither of those fields selected but still enough selections to take things to a reasonable number of rows.
If you use Calculation Conditions you should also explain to the user what you have done. Do this by clicking on the Error Messages button and then Calculation Condition Unfulfilled. This gives a box where you can type an explanation, such as Please Select Fewer Rows Of Data To View This Chart.
Also, you mention that all links are on a single key. If you can remove links from your data model - by merging data at load time - you may find performance improves. As it sounds like historical data can not change in this data set you should ensure you have an incremental load of that merged data.