topic Re: Unable to Make Calander from Timestamp in QlikView

Unable to Make Calander from Timestamp

brijeshvma — Fri, 12 Feb 2016 07:53:14 GMT

Hi All,

I have a Field as DateOfTravel , that is in Timestamp format. but i unable to Make Master Calander from this Field as well

i want Time Column as well in Calander .. Kinldy Help me for the same for time I Tried

Table:

LOAD *,

Time(Frac(TimeStamp#(TimeStampField, 'DD/M/YYYY h:mm:ssTT')), 'h:mmTT') as TimeField,

MyTable:

LOAD aDateOfTravel as DateOfTravel

FROM

(qvd);

But its not Happening ...Kinldy Help me for the same...

hcabrera — Fri, 12 Feb 2016 18:08:15 GMT

Hi,

If you try:

LOAD aDateOfTravel as DateOfTravel,

Time(aDateOfTravel) as TimeOfTravel

FROM

(qvd);

you have a time column, and you can try as time field in the calendar

I hope be your help,

Henry C.

sunny_talwar — Fri, 12 Feb 2016 18:31:24 GMT

I did respond to your previous post