topic Re: Data Modelling in QlikView

Data Modelling

Anonymous — Wed, 18 Nov 2015 06:24:56 GMT

Hi All,

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

Thanks in Advance,

Re: Data Modelling

gautik92 — Wed, 18 Nov 2015 06:28:49 GMT

sales table is fact and others are dimesions

Re: Data Modelling

prma7799 — Wed, 18 Nov 2015 06:32:49 GMT

Can you please send some sample application?

Re: Data Modelling

Anonymous — Wed, 18 Nov 2015 06:35:25 GMT

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

Re: Data Modelling

nagarjuna_kotha — Wed, 18 Nov 2015 06:36:15 GMT

Please share sample data

Regards,

Nagarjuna

Re: Data Modelling

Gysbert_Wassenaar — Wed, 18 Nov 2015 06:41:45 GMT

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

Please read these two documents:

Re: Data Modelling

Anonymous — Wed, 18 Nov 2015 06:47:27 GMT

I think, he got more than expected

Re: Data Modelling

Wed, 18 Nov 2015 07:05:19 GMT

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

];

Re: Data Modelling

jonathandienst — Wed, 18 Nov 2015 07:08:24 GMT

And also:
Get started with developing qlik datamodels

Advanced topics for creating a qlik datamodel