Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
raju_salmon
Creator II
Creator II

Linking master calender

Hi,

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 ??

1 Solution

Accepted Solutions
sunny_talwar

I guess the _Date field is read as text rather than TimeStamp here. Try this:

Date(Floor(Date#(Left(_Date, 9), 'DD-MMM-YY'))) as _Date

View solution in original post

3 Replies
sunny_talwar

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.

raju_salmon
Creator II
Creator II
Author

Hi Sunny,

Date(Floor(_Date)) as Date is not giving me the result. _Date field showing zero records.

sunny_talwar

I guess the _Date field is read as text rather than TimeStamp here. Try this:

Date(Floor(Date#(Left(_Date, 9), 'DD-MMM-YY'))) as _Date