Relations between different fileds Date

[#1]

Hi all!

I have a problem with the relations between three different fields Date.

My qlikview document has:

- MasterCalendar table, with a field MasterDate.

- Table Activity table, with a field DataInit and a field DataEnd.

- Other tables.

I want to create:

- A pivot table Arrives that counts the activity registers in a concrete DataInit.

- A pivot table Departures that counts the activity registers in a concrete DataEnd.

- A list box Calendar that shows the months of MasterCalendar.

I want that when I select a concrete month in Calendar, Arrives and Departures shows only the activity of this mount.

How can I do this? What is the best way to link MasterCalendar and Activity?

- I can't rename DataInit and DateEnd to MasterDate because they are in the same table. If I separate Activity table in two different tables (for example Arrives and Departures) a circular reference appears.

Any ideas? Thanks.

[jvitantonio]

in your pivot table, write the dimension like this:

=If(month(dateInit) = MonthFiledInCalendar, Arrives)

The same with Departures

MonthFiledInCalendar would be the field containing the month number in the table MasterCalendar.