Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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