topic Re: Making associative data model. in QlikView

Making associative data model.

agni_gold — Mon, 23 Dec 2013 04:56:57 GMT

Hi all ,

My question is that , how many way i can create associative data model in QV, please tell me every thing about this , means the functions , script and all the study material.

Re: Making associative data model.

sujeetsingh — Mon, 23 Dec 2013 05:54:51 GMT

Go to these links

http://community.qlik.com/thread/41345

The underlying technology of QlikView | DBMS 2 : DataBase Management System Services

http://community.qlik.com/blogs/theqlikviewblog/2010/08/16/qlikview-is-associative-to-its-very-core

Re: Making associative data model.

Anonymous — Mon, 23 Dec 2013 16:59:47 GMT

My first thought was - the endless number of ways. But in fact there is only one way. If you have fields with the same exact names (case-sensitive) in two or more logical tables, these tables are associated by this field. For example:

Table1 had fields Product, Store, Date, Region

Table2 has fields Date, Month, Year

Table3 has fields Product, Manufacturer, "Product Group"

Table1 is associated with the Table2 by the field Date, and Table1 is associate with the Table3 by the field Product.

That's it. Everything else follows from this simple rule.

Regards,

Michael