Re: information density and subset ratio? What is the use of this?
Mate, look for parent-child relationships between tables and go from there. For eg. Ticket Header Table - Ticket Details Table - there has to be a link between the 2 ie. Ticket No. in the details table is enough to bring all the details by the associative nature of qlikview - who needs the keys, throw in a counter field ie. set =1 , bobs your uncle.
I'm a SQL Server and Access DB expert - now building up in SAP BI so far only a practiioner - will be expert soon