Mapping Multiple Dates to a Single Date

[#1]

I have 5 date fields in two tables that represent different "actions" (order date, ship date, bill date, revenue recognized date and approved date). The issue I had in trying to "as" the dates is 4 of the 5 are in the same table.

In order to do month over month comparisons I need to have the dates map to a single date with differences being the value summed.

Any ideas??

Thanx

[#2]

HI see this link

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

It must help you.

[#3]

Seems to work when the dates are in different tables.....any idea how to handle it when all of the date names are in a single table?

[#4]

SET DateFormat='YYYY-M-D';

Data:

LOAD recno() as ID, * INLINE [

CreatedDate, DepartureDate, Value

2011-5-10,2011-5-15,10

2011-5-12,2011-5-15,20

2011-5-15,2011-5-16,40

];

Link:

LOAD

ID

,CreatedDate as Date

,'Created' as DateType

RESIDENT Data

;

CONCATENATE (Link)

LOAD

ID

,DepartureDate as Date

,'Departure' as DateType

RESIDENT Data

;

see the above example..

you have multiple dates in a table. Create a linkTable like above with datetypes and connect Date to your mastercalendar.

Hope that helps

Sravan

[#5]

For each type of event, use a LOAD with WHERE to pick up each one individually.

Assumming you are looking at something like a G/L, here is one example.