I am new to databases and qlikview, hence seems like basis question.
I have created master calendar using attached script.
In my Sales Table I have date fields in below format. When i am linking this Date field with Calendar Date i can able to link. Is it because of two different formats? What changed i need to do in ca lender script? Any suggestions whether i can modify below database date field or ??
Your date is actually a timestamp. Either you can change your timestamp to a date -> Date(Floor(_Date)) as Date or you need to create a master Time Table (The Master Time Table) in addition to master calendar.