mulitilple dates in more than one fact table

[Anonymous]

Hi All,

Please help me in solving the problem,

1)how to create master calendar if more number of date field available in fact table

2) how to show loano which are apporved and rejected in a bar chart

Example

Fact1:

Loanno,

Approvaldate,

RejectDate,

CancelDate,

Lastupdatedate

Amount

Fact2:

Loanno,

Lastupdatedate,

DueDate,

EmiDate,

Intereset

Thanks in advance

[Anonymous]

First, it is better to have one and only one Fact table.  About how - something like that (and only one calendar):

Fact:
LOAD
Loanno,
Approvaldate as Date,
Amount,
'Approval' as Flag
RESIDENT Fact1;

CONACTEANTE (Fact) LOAD
Loanno,
RejectDate as Date,
Amount,
'Rejected' as Flag
RESIDENT Fact1;

CONACTEANTE (Fact) LOAD
Loanno,
CancelDate as Date,
Amount,
'Canceled' as Flag
RESIDENT Fact1;

CONACTEANTE (Fact) LOAD
Loanno,
Lastupdatedate as Date,
Amount,
'Last Updated' as Flag
RESIDENT Fact1;

CONACTEANTE (Fact) LOAD
Loanno,
DueDate as Date,
Interest,
'Due' as Flag
RESIDENT Fact2;

CONACTEANTE (Fact) LOAD
Loanno,
Lastupdated as Date,
Interest,
'Last Updated' as Flag
RESIDENT Fact2;

CONACTEANTE (Fact) LOAD
Loanno,
EmiDate as Date,
Interest,
'Emi' as Flag
RESIDENT Fact2;

Regards,
Michael

[rwunderlich]

This discussion may. Be helpful

http://community.qlik.com/message/283501#283501

Rob