topic Re: Reformat Data in QlikView

Reformat Data

Fri, 26 Jun 2015 14:02:01 GMT

Just wondering if anyone can help me I had a huge file with dates formatted like 01/03/2014 etc and I wanted to get them into months and years.

So I loaded the data in like Date, MonthName(Date) as MonthYear and this is giving me a listbox with months and years grouped together e.g. Mar 15, Apr-15 etc.

I was wondering is their anyway I can put this information into two seperate list boxes one for the months and once for the years it would make it much easier for creating charts.

Re: Reformat Data

MK_QSL — Fri, 26 Jun 2015 14:05:23 GMT

Load

Date

Month(Date) as Month,

Year(Date) as Year,

Week(Date) as Week

From FileName;

Re: Reformat Data

awhitfield — Fri, 26 Jun 2015 14:08:13 GMT

Hi Use,

create another 2 fields

Month(Date) as Month and Year(Date) as Year

HTH - Andy

Re: Reformat Data

Fri, 26 Jun 2015 14:40:51 GMT

Cheers lads both worked.

thanks.

Re: Reformat Data

awhitfield — Fri, 26 Jun 2015 14:45:43 GMT

Cheers Sue, it's a long time since I've been called a lad - ha ha !!