Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

vb00494773
New Contributor III

Qlik sense time series problem

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 .

time.PNG

Venkatesh