Discussion board where members can learn more about Qlik Sense Data Connectivity.
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.
Go to Solution.
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
Try this out:
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.
Provide me with the raw data and I might be able to help you out
Here is the link containing the raw data.
Raw Data - Google Drive
Thanks a ton for the help
Here is the attached sample.