Merge date to one calendar

[suzel404]

Hello,

How can i merge date to create one calendar:

Expense:

LOAD

     ExpenseIdentifier,

     ExpenseDate

     Amount

From Expense.qvd(qvd);

Transaction:

LOAD

     TransactionIdentifier,    

     ExpenseIdentifier,

     StartDate,

     EndDate

FROM Transaction.qvd(qvd);

My solution:

LOAD

     ExpenseIdentifier,

     ExpenseDate AS CalendarDate,

     Amount

From Expense.qvd(qvd);

OUTER JOIN

LOAD

     ExpenseIdentifier,

     StartDate AS CalendarDate,

     1 AS Transaction

FROM Transaction.qvd(qvd);

OUTER JOIN

LOAD

     ExpenseIdentifier,

     EndDate AS CalendarDate,

     1 AS Transaction

FROM Transaction.qvd(qvd);

Do you have better suggestion, please ?

Regards.

[vunguyenq89]

You should create a master (common) calendar for the 3 date fields in your data model. This article presents a very comprehensive tutorial for master calendar: Search Recipes | Qlikview Cookbook

[tharanikannan · Accepted solution]

Hi,

I believe , this is not the right way to do.

Please identify key date filed from your data. You can create your master calendar from the date filed of Fact table . You cant do join this way. already your both tables are connected using this "ExpenseIdentifier". So please identify the date from which you can derive your master calender.

Thanks,

Tharani.

[Anonymous]

Hi

To merge dates you have to use MasterCalender

Using it multiple dates can be merged to form a single date

Thanks