Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld May 10-12, Online and Free! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rupeshshah
Partner
Partner

DATA MODELING ISSUES WITH MULTIPLE DATE

HI ALL,

i have a excel file there are all table has date,

how to make data model with connect master calendar connect all date

 

2 Replies
stevedark
MVP
MVP

Hi @rupeshshah 

I always find the best way is to create the calendar inline with the load, like this:

LOAD
  [Asset ID],
  [Asset Name],
  [Lot Size],
  Country,
  [Asset Status],
  [Ownership %],
  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]
(ooxml, etc.);

 

You can carry on adding as many date parts as you like to the script, finding WeekDay, Quarter etc. etc.

Cheers,
Steve

rupeshshah
Partner
Partner
Author

HI @