Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
rathnam_qv
Creator
Creator

Data Model

hi all,

can any one explain how to build a perfect datamodel.....with examples...please

Thanks in advance!!!

Smiley

1 Reply
Siva_Sankar
Master II
Master II

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