Relations between different fileds Date

Tue, 20 Mar 2012 10:45:58 GMT

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.

Relations between different fileds Date

jvitantonio — Tue, 20 Mar 2012 10:51:28 GMT

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.

topic Relations between different fileds Date in QlikView

Relations between different fileds Date

Relations between different fileds Date