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.
Solved! Go to Solution.
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.