topic Re: How to create year field in QlikView

How to create year field

NavinReddy — Wed, 18 Jun 2014 18:59:39 GMT

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

Re: How to create year field

joshabbott — Wed, 18 Jun 2014 19:59:14 GMT

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

Re: How to create year field

Wed, 18 Jun 2014 20:07:16 GMT

Hi,

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

Year(Today()) as Year,

Best Regards.

Re: How to create year field

NavinReddy — Wed, 18 Jun 2014 20:19:23 GMT

greate thought

Thanks you somuch really its help full i wil try

Re: How to create year field

MarcoWedel — Sun, 22 Jun 2014 23:51:34 GMT

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

Re: How to create year field

MarcoWedel — Wed, 09 Jul 2014 12:26:36 GMT

Hi,

please close this thread if there are no further questions.

Thanks

Regards

Marco