topic Re: Period Conversions in QlikView

Period Conversions

Thu, 18 Dec 2014 10:43:28 GMT

Hi All,

I have Period Wise data in my table like 201401,201402,201403........201412 but as my requirement I need to display like

January 2014 ,February 2014,March 2014

in my pivot table can anybody help me on this..

Thanks,

kishore.

tresB — Thu, 18 Dec 2014 10:45:50 GMT

Try this:

Date(Date#(YourField, 'YYYYMM'), 'MMMM YYYY')

Thu, 18 Dec 2014 10:54:24 GMT

Date(makedate(left(YourField,4),right(YourField,2),1), 'MMMM YYYY')

Thu, 18 Dec 2014 11:07:28 GMT

Hi kishore

you can try with this below function

Date(makedate(left(YourField,4),right(YourField,2),1), 'MMMM YYYY')

Thanks