topic Count Month in QlikView

Count Month

Fri, 31 Jul 2009 19:27:14 GMT

Hi,

Below expression returns Jan 2008 to jun 2008. I need to count the no. of month between them:

MonthName(YearStart(Date#( Year(Today())-1, 'YYYY') )) &' to '& month(addmonths(Today(),-1)) &' ' &(Year(Today())-1)

If possible, let me know some other way to calculate no. of months between starting of year to lst month as done above.

Thanks,

Sunil

Count Month

disqr_rm — Fri, 31 Jul 2009 20:39:23 GMT

Wouldn't that be same as number of last month, like 6 for june, since you are always workign with current year only?

If this is correct, you can get that by using: num(month(addmonths(Today(),-1)))

Hope I answered what you are looking for.

Count Month

Fri, 31 Jul 2009 21:12:01 GMT

Sunil,

Because Months are usually stored as a Dual (meaning they have both a numeric and a text representation) you can actually just subtract them to find the number fo months between them. A work of caution though, this only works if you are staying in the same year. If you are crossing years you must account for that.

So, given your example, something like this should work:


Month(AddMonths(Today(),-1)) - Month(YearStart(Today()))

This will give you the number of months between last month and the start of the year.

Thanks

sjprows

Count Month

disqr_rm — Fri, 31 Jul 2009 21:16:29 GMT

Month(YearStart(Today())) is always 1 so you might hard code it as 1.