Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

raju_salmon
Contributor

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

Re: Linking master calender

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

3 Replies
MVP
MVP

Re: Linking master calender

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
Contributor

Re: Linking master calender

Hi Sunny,

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

MVP
MVP

Re: Linking master calender

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