topic Re: Date in QlikView

Date

Mon, 17 Aug 2015 08:48:16 GMT

Hi Qlik Community,

I was wondering of it's possible that the MM/DD/YYYY format in database can be converted Month, Date and Year Individually on qlikview?

for example the 1/1/2005, i want it to be in the different table like Month = Jan, Date = 1 and Year = 2005

Here is the date i need to convert:

1/1/2005

1/19/2006

9/13/2006

11/2/2006

11/6/2006

11/7/2006

11/8/2006

11/9/2006

11/13/2006

11/14/2006

11/15/2006

11/16/2006

11/17/2006

11/21/2006

11/22/2006

11/23/2006

11/24/2006

11/27/2006

11/28/2006

11/29/2006

11/30/2006

12/4/2006

12/5/2006

12/6/2006

12/7/2006

12/13/2006

12/21/2006

12/22/2006

12/27/2006

12/28/2006

12/29/2006

1/2/2007

1/3/2007

1/4/2007

1/5/2007

1/8/2007

1/9/2007

1/10/2007

1/11/2007

Thanks in advance

Re: Date

sunny_talwar — Mon, 17 Aug 2015 08:50:59 GMT

You can do it in the script:

LOAD Date,

Day(Date) as Day,

Month(Date) as Month

Year(Date) as Year

FROM Source

Re: Date

Mon, 17 Aug 2015 09:02:12 GMT

Ya it's possible with data functions

you can derive the new fields using the date functions applying on your date field in the script level

Ex:

Month(Your_Date_Field) as Month,

Year(Your_Date_Field) as Year,

Day(Your_Date_Field) as Day

Qlikview has many functions, you can check in Help, it will give you much stuff you.

Regards

AR UMAMAHESH

Re: Date

Mon, 17 Aug 2015 09:04:32 GMT

thanks sir