topic Re: Split a date into Month and Year in QlikView

Split a date into Month and Year

Anonymous — Thu, 05 May 2016 12:23:12 GMT

Hi,

i would like to create new dimension through the master item.

the new dimension is suppose to present the month and the year of another full date field that is already existing in the data set.

what is the function that i should write in order to receive such a value?

thanks,

Tal

Re: Split a date into Month and Year

Colin-Albert — Thu, 05 May 2016 15:01:11 GMT

Add these lines to your load script setting the correct filed name for date_field

month(date_field) as month,

year(date_field) as year,

Re: Split a date into Month and Year

sunny_talwar — Thu, 05 May 2016 15:01:42 GMT

For Month you need Month() and for year you can use Year(). There are other Date and Time related functions which you can find in the help section. One thing to make sure before you use these functions is that the date is read correctly by QlikView

Why don’t my dates work?

Get the Dates Right

Re: Split a date into Month and Year

pooja_sn — Thu, 05 May 2016 15:45:20 GMT

MonthName(Date) will return 'MMM YYYY' eg. Mar 2016

Re: Split a date into Month and Year

Thu, 05 May 2016 16:52:17 GMT

Try below code in scripting

Month(datefield) as Month,

Year(datefield) as Year