If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
i have a excel file there are all table has date,
how to make data model with connect master calendar connect all date
I always find the best way is to create the calendar inline with the load, like this:
Date([Last Updated], 'DD MMM YYYY') as [Last Updated],
Date(MonthStart([Last Updated]), 'MMM-YYYY') as Month,
Month([Last Updated]) as [Month Name],
Year([Last Updated]) as Year
FROM [lib://MyLibrary/Real Estate Data.xlsx]
You can carry on adding as many date parts as you like to the script, finding WeekDay, Quarter etc. etc.
Thanx for give me soluation.