Converted Year from Date is not pupulating correctly

[mhmmd_srf]

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.

[qlikviewwizard · Accepted solution]

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);