topic Re: Multiple tables with multiple date fields but client users want a calendar that interacts with all tables in QlikView

Multiple tables with multiple date fields but client users want a calendar that interacts with all tables

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I'm working with a large number of tables that all have different dates fields but my end users only want one Year / Week / Month list box to make selections.

What is the best way to achieve this?

The background to this query is we currently use a calendar created from the time sheet date field from a time sheet header table, this holds current and past dated transactions. However, we have a new table for holiday bookings that shows future dated transactions.

When I change the calendar creation to use the holiday booking date I'm losing employees off my report who have not yet booked a holiday but do have time sheets.

All suggestions welcome,

Trudie

Re: Multiple tables with multiple date fields but client users want a calendar that interacts with all tables

sunny_talwar — Fri, 03 Nov 2017 18:20:34 GMT

check this

Canonical Date

Re: Multiple tables with multiple date fields but client users want a calendar that interacts with all tables

MK9885 — Fri, 03 Nov 2017 18:24:39 GMT

One Fact with Date entries from other dimensions mapping to Master Calendar.

You can probably do left join with the key you've to the fact for the date fields. This way the Fact contains all the dates?

Not sure but can you pot a sample data and expected output as well?

Re: Multiple tables with multiple date fields but client users want a calendar that interacts with all tables

satishkurra — Fri, 03 Nov 2017 19:12:01 GMT

ALso this

Tutorial - Using Common Date Dimensions and Shared Calendars