topic Re: Mapping Multiple Dates to a Single Date in QlikView

Mapping Multiple Dates to a Single Date

Fri, 27 May 2011 13:36:49 GMT

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

Mapping Multiple Dates to a Single Date

Fri, 27 May 2011 13:54:22 GMT

HI see this link

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

It must help you.

Mapping Multiple Dates to a Single Date

Fri, 27 May 2011 14:05:10 GMT

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?

Mapping Multiple Dates to a Single Date

Fri, 27 May 2011 14:14:39 GMT

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

Re: Mapping Multiple Dates to a Single Date

Sat, 28 May 2011 17:14:24 GMT

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.