0 Replies Latest reply: Feb 10, 2017 2:41 PM by Venkatesh botla RSS

    Qlik sense time series problem

    Venkatesh botla

      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