Combined Calendar

Mon, 08 Sep 2014 10:44:38 GMT

Hello,

I have been struggling with creating a combined Master Calendar.

I now have the following problem:

There are two databases for our customers, one which contains two dates, the one at which the customer registered and the one at which he became active.

In the second database there are the transactions he has been doing over the time.

I am now trying to put this into one calendar so I can see -by filtering-, how many customers registered in a certain month, as well as how many transactions were processed.

I think the problem here is that there is only 1 date of registration resp. activation for a customer but there can be more than one date of transaction.

My code looks like this:

DateLink:

Load

fk_merchant_id,

month(DateReg) as Month,

year(DateReg) as Year,

'Reg' as DateType

Resident DB1;

Load

fk_merchant_id,

month(DateAct) as Month,

year(DateAct) as Year,

'Act' as DateType

Resident DB1;

Load

fk_merchant_id,

month(transactionDate) as Month,

year(transactionDate) as Year,

'TRX' as DateType

Resident DB2;

When I filter for a month it shows me the correct Registrations and activations but the TRx Data is accumulated until that very date.

Does it even make sense to create a master calender like this or should I create one for both databases.

Thanks a lot for helpful advise

Benjamin

Re: Combined Calendar

maleksafa — Mon, 08 Sep 2014 10:49:33 GMT

you can link all your date fields to the same master calendar, using the canonical calendar, check the below link:

http://community.qlik.com/blogs/qlikviewdesignblog/2014/02/17/canonical-date

topic Combined Calendar in QlikView

Combined Calendar

Re: Combined Calendar