Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Not applicable

Multiple Dates in multiple tables - Linking them

Hi,

I'm new to QlikSense.

I have data in four sheets - "Booking","Posting","Expense","Hostel"

Each of these sheets contain multiple date columns:

Booking Table: [Booked Date],[Arrival Date],[Departure Date],[Void Date],[No Show Date],[Cancelled Date]

Posting Table: [Date]

Expense Table :[Voucher Date]

Hostel Table: [Date]

Can I combine these dates into a single calendar? I want to use date as a filter to calculate various fields from these tables.

Thanks

1 Solution

Accepted Solutions

Re: Multiple Dates in multiple tables - Linking them

Can you just attach it here (I don't have access to Google Drive at my work)

Uploading a Sample

View solution in original post

6 Replies

Re: Multiple Dates in multiple tables - Linking them

Try this out:

Canonical Date

Not applicable

Re: Multiple Dates in multiple tables - Linking them

Hey Sunny T,

Can you help me out with this in a bit more detail?

Can you provide me with a script for creating this canonical date? Booking table should be the fine grain I think.

Re: Multiple Dates in multiple tables - Linking them

Provide me with the raw data and I might be able to help you out

Not applicable

Re: Multiple Dates in multiple tables - Linking them

Hi Sunny,

Here is the link containing the raw data.

Raw Data - Google Drive

Thanks a ton for the help

Re: Multiple Dates in multiple tables - Linking them

Can you just attach it here (I don't have access to Google Drive at my work)

Uploading a Sample

View solution in original post

Not applicable

Re: Multiple Dates in multiple tables - Linking them

Sure ,

Here is the attached sample.