How to create year field

[NavinReddy]

Dear All,

I have month wise but i want to create year Field

please find the attechment

i tried with cross table but dont know how to achive it

the same way i have data 2012,2013 also have

please some one help me to do this

Thanks In Advance

Niranjan

[joshabbott]

So you have three separate spreadsheets for three separate years?  Couldn't you just add a 'Year' column to the spreadsheet is my though?

[#3]

Hi,

If value of my year field were actual year... I just get year value with this:

Year(Today()) as Year,

Best Regards.

[NavinReddy]

greate thought

Thanks you somuch really its help full i wil try

[MarcoWedel · Accepted solution]

Hi Niranjan,

given the data for different years resides in seperate files with filenames ending with the year number, one solution could be also:

Set LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';

table1:
CrossTable (monthtemp, value, 3)
LOAD Right(FileBaseName(), 4) as year, *
FROM [QlikCommunity_Thread_122484_*.xlsx]
(ooxml, embedded labels, table is Sheet1);

Left Join(table1)
LOAD Distinct
  monthtemp,
  Date#(monthtemp, 'MMM') as month
Resident table1;

DROP Field monthtemp;

hope this helps

regards

Marco

[MarcoWedel]

Hi,

please close this thread if there are no further questions.

Thanks

Regards

Marco