Qlik sense time series problem

[vb00494773]

Hi Guys,

Please help for adding the the time and minutes and sec in the auto generated script which was created by qlik sense while preparing data.

.

[autoCalendar]:

  DECLARE FIELD DEFINITION Tagged ('$date')

FIELDS

  Dual(Year($1), YearStart($1)) AS [Year] Tagged ('$axis', '$year'),

  Dual('Q'&Num(Ceil(Num(Month($1))/3)),Num(Ceil(NUM(Month($1))/3),00)) AS [Quarter] Tagged ('$quarter', '$cyclic'),

  Dual(Year($1)&'-Q'&Num(Ceil(Num(Month($1))/3)),QuarterStart($1)) AS [YearQuarter] Tagged ('$yearquarter', '$qualified'),

  Dual('Q'&Num(Ceil(Num(Month($1))/3)),QuarterStart($1)) AS [_YearQuarter] Tagged ('$yearquarter', '$hidden', '$simplified'),

  Month($1) AS [Month] Tagged ('$month', '$cyclic'),

  Dual(Year($1)&'-'&Month($1), monthstart($1)) AS [YearMonth] Tagged ('$axis', '$yearmonth', '$qualified'),

  Dual(Month($1), monthstart($1)) AS [_YearMonth] Tagged ('$axis', '$yearmonth', '$simplified', '$hidden'),

  Dual('W'&Num(Week($1),00), Num(Week($1),00)) AS [Week] Tagged ('$weeknumber', '$cyclic'),

  Date(Floor($1)) AS [Date] Tagged ('$axis', '$date', '$qualified'),

Date(Floor($1), 'D') AS [_Date] Tagged ('$axis', '$date', '$hidden', '$simplified');

DERIVE FIELDS FROM FIELDS [dateandtime] USING [autoCalendar] ;

i want to know how to add minutes and sec level, However i have tried adding like below but it is not working in line chart .

//   Time($1) as time1 Tagged ('$axis', '$time1', '$qualified','$cyclic'),

//   hour($1) as onehour Tagged ('$axis', '$onehour', '$qualified', '$cyclic'),

//minute($1) as minutes Tagged ('$minutes', '$qualified'),

//minute(Floor($1), 'M') AS [_minutes] Tagged ('$minutes', '$hidden', '$simplified'),

//   Second($1) as Seconds Tagged ('$axis', '$Seconds', '$qualified', '$cyclic'),

FYI, in the attached image , you can see the line chart but if you see, i have hour info but i need to deep inside like minutes and sec in the same hour of line chart .

Thanks in advance .

Venkatesh