Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
So you have three separate spreadsheets for three separate years? Couldn't you just add a 'Year' column to the spreadsheet is my though?
Hi,
If value of my year field were actual year... I just get year value with this:
Year(Today()) as Year,
Best Regards.
greate thought
Thanks you somuch really its help full i wil try
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
Hi,
please close this thread if there are no further questions.
Thanks
Regards
Marco