Common calendar for two Date field in the same table

Mon, 14 Nov 2011 14:29:04 GMT

Hi,

Need help on building up a data model with 2 date fields. I am looking for an analysis based on Clearing dates & Posting using a common date table I have attached a file with the data and the result which I am looking for when I select a month ( for my example its Oct)

Regards,

Rufus Lopes

Re: Common calendar for two Date field in the same table

johnw — Tue, 15 Nov 2011 01:45:48 GMT

Attached is an example of trying two date fields in the same table to a common Date field, which is what would then connect to your calendar. Script below minus the calendar, which would be built like any other calendar.

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:
CROSSTABLE (DateType, Date)
LOAD
ID
,CreatedDate as Created
,DepartureDate as Departure
RESIDENT Data
;

topic Common calendar for two Date field in the same table in QlikView

Common calendar for two Date field in the same table

Re: Common calendar for two Date field in the same table