topic Re: 1 Year selection, 2 date fields in QlikView

1 Year selection, 2 date fields

pauldamen — Thu, 07 Jan 2016 09:46:46 GMT

All,

I have a project dashboard with projects obviously having a start date and a end date. I have a mastercalender based on the 2 date fields.

But when I have my year selection box and I select 1 year it only shows the projects that have a startdate that year. How can I make a year selection and see both the projects starting that year, but also projects ending that year and running throughout that year?

Regards, Paul

Re: 1 Year selection, 2 date fields

MK_QSL — Thu, 07 Jan 2016 09:49:15 GMT

Create Canonical Calendar and use Year from this calendar.

Canonical Date

Re: 1 Year selection, 2 date fields

pauldamen — Thu, 07 Jan 2016 09:56:51 GMT

Ok the solution proved to be quite simple, I just had to load:

StartDate, EndDate as Year

Regards, Paul

Re: 1 Year selection, 2 date fields

Anonymous — Thu, 07 Jan 2016 10:01:39 GMT

check this as well:

Using Multiple Dates With Master Calendar

Master Calendar Date from Multiple dates in dataset