topic Re: Data Modelling in QlikView

Data Modelling

Anonymous — Tue, 13 May 2014 05:04:50 GMT

Hello,

Need a small help in Data Modelling....

I am working on a data model where most of the tables are having one common field say ID which can create looping in model.

For example say:

Table1,Table2,Table3 is having ID and they are interlinked(One field into multiple table) with each other.

I tried for Composite Key as well but their is no other common field so that my Table1 is linked to Table2 with a unique key and my Table3 is linked to either of the Table1 or Table2 by a another unique field.

So, is there any way to do this kind of modelling when you are having only one common field in multiple tables???

Thanks in advance.

Regards,

Balraj Ahlawat

Re: Data Modelling

Anonymous — Tue, 13 May 2014 05:15:39 GMT

I dont think that if only one field is in common in all tables then there will be any loop,

I think , according to below image , model would be created....

if this does not help then please elaborate more on your issue for better understanding..

Re: Data Modelling

Anonymous — Tue, 13 May 2014 05:20:31 GMT

Nitin,

Thanks for Immediate response.

Same thing I am getting....

Just want to check is this good for data modelling??

Regards,

Balraj Ahlawat

Re: Data Modelling

sujeetsingh — Tue, 13 May 2014 05:22:00 GMT

Of course

Re: Data Modelling

sujeetsingh — Tue, 13 May 2014 05:22:33 GMT

Go to this doc

Best Practices for Data Modelling

Re: Data Modelling

senpradip007 — Tue, 13 May 2014 05:26:17 GMT

Can you share your data model?

Re: Data Modelling

Anonymous — Tue, 13 May 2014 05:27:02 GMT

Thanks Sujeet.

Re: Data Modelling

Anonymous — Tue, 13 May 2014 05:27:49 GMT

Thanks for sharing very useful document

anant

Re: Data Modelling

its_anandrjs — Tue, 13 May 2014 05:28:46 GMT

You can try with this code also

Suppose there is scenario then us unqualify function for this.

QUALIFY *;

UNQUALIFY ID;

LOAD * INLINE [

ID, Field1, Field2, Field3

1, 2, 3, 4

];

LOAD * INLINE [

ID, Field1, Field2, Field3

1, 2, 3, 4

];

LOAD * INLINE [

ID, Field1, Field2, Field3

1, 2, 3, 4

];

Re: Data Modelling

Anonymous — Tue, 13 May 2014 05:32:12 GMT

Pradip,

Nitin have already given the model....

Regards,

Balraj Ahlawat

Re: Data Modelling

Anonymous — Tue, 13 May 2014 05:52:34 GMT

Sujeet,

One more thing I would like to check....

Will it make any impact on the Data Model if we join say Tab3 to either of the Table like Tab1 or Tab2?

Regards,

Balraj Ahlawat