In qlikview, the recommendations on the data modeling aren't every the same. For example, for an aplication, Linked tables would be better than Concatenated Linked Tables. In other cases, would be exactly opposite. There are general recommendations, like remember that distinct and short values takes more resources than no distinct but heavy ones. In qlikview, for example in most cases, the concatenation o joined of Header and Body tabler works better that mantain both tables. There several parameters that you must take on mind, and your modeling job would follow your proority: - Staging time - Data storage space - Portability of the aplication - Performance of the dashboard - Objetive of the dashboard (analisis, reports, viewing, etc) The following blog will be helpful in building perfect data model in qlikview. http://www.quickintelligence.co.uk/perfect-your-qlikview-data-model/ regards. siva
