Data Modelling

[Anonymous]

Hi All,

  I have 5 tables as shown below. can someone model this tables. I also want master calendar.

Thanks in Advance,

[gautik92]

sales table is fact and others are dimesions

[prma7799]

Can you please send some sample application?

[Anonymous]

1)Join Sales and Collections table based on Invoice No(Maintain a Flag for Sale & Collection in table) - Fact Table

2) Link Sales Person to Fact Table via Customer Code - Dim Table

3) USe mapping load/applymap for Branch Table to get Region Field from Region Table into Branch Table - Dim Table

4) Link both the DIm Table via Branch Code

5) Create MAster Calender based on Invoice Date.

Hope this will help

[nagarjuna_kotha]

Please share sample data

Regards,

Nagarjuna

[Gysbert_Wassenaar]

And do you have a question? Or is this an attempt to get other people to do your work?

Please read these two documents:

• QlikCommunity Tip: How to get answers to your post?
• Preparing examples for Upload - Reduction and Data Scrambling

[Anonymous]

I think, he got more than expected

[#8]

According to Balraj Ahlawat comment ,

[Region Table]:

Mapping

load * inline [

Region Code,Region ];

[Branch Table]:

LOAD * inline [

applymap('Region Table',Region Code) as Region Code ,Branch Code, Branch ];

[Sales Person]:

load * inline [

Branch Code,Sales Person Type,Sales Person Code,Sales Person Name,Customer Code

];

[Sales Data]:

load * inline [

Customer Code,Customer Name,Invoice No,Invoice Date,Invoice Amt

];

join([Sales Data])

Collections:

load * Inline [

Invoice No,Pay Ref.No,Pay Ref Date,Pay Amt

];

[jonathandienst]

And also:
Get started with developing qlik datamodels

Advanced topics for creating a qlik datamodel

More advanced topics of qlik datamodels