Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You can do it in the script:
LOAD Date,
Day(Date) as Day,
Month(Date) as Month
Year(Date) as Year
FROM Source
You can do it in the script:
LOAD Date,
Day(Date) as Day,
Month(Date) as Month
Year(Date) as Year
FROM Source
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
thanks sir