topic Re: How to make a MonthYear format? in QlikView

How to make a MonthYear format?

Thu, 11 Apr 2013 04:17:28 GMT

i have a data called dates, and i only need to get the month and year.

and a friend of mine told me to use 'Floor' , 'MonthStart' , 'Date' to extract Month and Year. how can i use these functions in my codes

Re: How to make a MonthYear format?

alexandros17 — Thu, 11 Apr 2013 15:52:22 GMT

if your date is 2013 April 14 then:

your monthyear field will be

year(mydate)*100 + month(mydate)

so 2013*100 = 201300 + 4 => 201304

hope it helps

Re: How to make a MonthYear format?

ceciliafujita — Thu, 11 Apr 2013 18:36:00 GMT

you can do:

num(Month(yourdate),00) & Year(yourdate,4) as MonthYear

Re: How to make a MonthYear format?

Mon, 29 Apr 2013 08:42:29 GMT

what i did is date(myDate, 'MMM-YYYY')

Re: How to make a MonthYear format?

hic — Mon, 29 Apr 2013 10:45:02 GMT

Formatting it using Date(myDate, 'MMM-YYY') is the right approach but it only solves half of the problem. It only hides the day part. It does not remove it. If you want to do it properly, you should use a MonthStart() first, i.e.

Date(MonthStart(myDate), 'MMM-YYYY')

HIC

Re: How to make a MonthYear format?

Mon, 06 May 2013 05:45:16 GMT

Thank you sir! it does solve my problem

thanks again.