Qlik Community

Qlik Sense Data Connectivity

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

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
MVP
MVP

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

6 Replies
MVP
MVP

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.

MVP
MVP

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

MVP
MVP

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

Not applicable

Re: Multiple Dates in multiple tables - Linking them

Sure ,

Here is the attached sample.