How To Create A Master Calendar For Two Date Fields

Mon, 11 Mar 2013 12:16:55 GMT

Hi,

I have two tables with different date fields - JoinDate and ReleaseDate from two connected tables.

I want to have a common Time dimension to avoid using both the fields individually for analyzing against the Time (Date,Day,Week,Month fields) dimension.

I do not want to create a seperate master calendar for each date field, rather I'd like to have only one master calendar for all the date fields.

For example, I select March from the Month dimension, I should be able to get:

- value as 1 for No of persons who left in March

- value as 2 for No of persons who joined in March

- value as 3 for all persons in March

How can I use a master calendar to achieve common time dimensions in this scenario?

Please find the sample attached.

Thanks,

-Khaled.

Re: How To Create A Master Calendar For Two Date Fields

Mon, 11 Mar 2013 20:15:27 GMT

You can also try something like this for your expression. This will work for any calendar value such as Year, Month, Qtr etc.

The format of the dates will need to be the same.

Count ({<ReleaseDate= {'>=$(=MIN(CAL_DATE))<=$(=Max(CAL_DATE))'}>}PersonId)

Count ({<JoinDate= {'>=$(=MIN(CAL_DATE))<=$(=Max(CAL_DATE))'}>}PersonId)

topic Re: How To Create A Master Calendar For Two Date Fields in QlikView

How To Create A Master Calendar For Two Date Fields

Re: How To Create A Master Calendar For Two Date Fields