Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am working in Qlik Sense.
I have an excel file having a date field called Created.
I want to extract year. It is happening but year is repleting for each day.
My script is like below:
Created, | |
Date(Created,'DD/MM/YYYY') as DT, | |
Date(Date(Created,'DD/MM/YYYY'),'YYYY') as Year, |
and Year is coming like below:
I am attaching the excel file.
Could any one help me on this.
Hi,
Check this.
Tickets:
LOAD *,Year(Created) as Year,Month(Created) as Month;
LOAD Number,
date(left(Created,5),'DD-MMM-YY') as Created,
Created as Created_Original,
State,
[Short description],
[Task type],
[Assigned to],
Priority,
Closed,
Tags
FROM
[..\..\Downloads\Test Data.xlsx]
(ooxml, embedded labels, table is Tickets);
Hi,
Check this.
Tickets:
LOAD *,Year(Created) as Year,Month(Created) as Month;
LOAD Number,
date(left(Created,5),'DD-MMM-YY') as Created,
Created as Created_Original,
State,
[Short description],
[Task type],
[Assigned to],
Priority,
Closed,
Tags
FROM
[..\..\Downloads\Test Data.xlsx]
(ooxml, embedded labels, table is Tickets);