Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.