Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ??
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
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.
Hi Sunny,
Date(Floor(_Date)) as Date is not giving me the result. _Date field showing zero records.
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