Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

paulyeo11
Valued Contributor II

Can some one share with me my data model perfect ?

Hi All

Last week after i post the below post , i get many response to help me , In order to confirm my data model is perfect , i like to create a new post on this.

it my data model perfect ?

After i remove SOURCE field from below table  :-

AP Aging

AR Aging

ARSummary


I also give the above table unique name for cust_id and company. My my data model as below :-


MY TABLE PERFECT NOW.dib


Now i think my data model is perfect right ?


Paul

4 Replies

Re: Can some one share with me my data model perfect ?

Perfect is kind of  a big word.

You do not have synthetic keys that for sure ,but I can see that you got TERMS and terms  and IDSE and iDSE fields.

Do they differ?

You can test your model with rwunderlich

Document Analyzer

to see if there could not possible improvement.

Re: Can some one share with me my data model perfect ?

Take a look here: A perfect datamodel?

- Marcus

paulyeo11
Valued Contributor II

Re: Can some one share with me my data model perfect ?

Hi Marcus

Thank you for your feedback.

The reasons I make my data model W/o sync key , is I realise under my situation , this will not create issue when I load all my actual data into QV.

Paul Yeo

Director

www.tdstech.com<http://www.tdstech.com>

HP+6285883521036 Indo

paulyeo11
Valued Contributor II

Re: Can some one share with me my data model perfect ?

Hi Marcus

Thank you for the link.

Paul

Community Browser