topic Re: Date Range in QlikView

Date Range

Tue, 29 Jan 2013 11:32:54 GMT

I have two dimensions in my report (pivot or straight) displaying start date & end date. Now i want to display all the dates between start date & end date.

Re: Date Range

RedSky001 — Tue, 29 Jan 2013 15:19:40 GMT

You'll need to create a Calendar and use the intevalmatch function (see below for an example)

Calendar:

LOAD

Date('01/01/2011' + RowNo() - 1) AS Date

AUTOGENERATE 3000;

Transactions:

load * Inline [StartDate,EndDate

01/01/2012,01/06/2012

];

Inner Join IntervalMatch (Date) LOAD

StartDate, EndDate

RESIDENT Transactions;

Re: Date Range

Wed, 30 Jan 2013 16:26:06 GMT

Xooooooooooooow, Tanks msheraton

Re: Date Range

RedSky001 — Wed, 30 Jan 2013 16:38:03 GMT

Please can you mark my post as correct, thanks