topic Re: Months caluculation in QlikView

Months caluculation

Mon, 26 Dec 2011 10:14:01 GMT

Dear All

I want to caluculate Diff in months please help me with backend script

rohit214 — Mon, 26 Dec 2011 10:25:25 GMT

try this

in script

num(month(BookMonth) as BookMonth,

num(Month(today() ) as taday,

num(Month(today() ) - num(month(BookMonth) as Diff

in expression

today-bookMonth

may it helps you

thanks

rohit

SunilChauhan — Mon, 26 Dec 2011 10:57:51 GMT

try this

interval(Today- BookDate,MM)

Clever_Anjos — Mon, 26 Dec 2011 15:50:40 GMT

LET d1 = today();

LET d2 = '01/02/2005';

LET MonthsBetween = year(d1)*12 - Month(d1) - (year(d2)*12 - Month(d2));

Mon, 26 Dec 2011 20:12:31 GMT

Hi,

((Year(BookDate)-Year(Today()))*12)+(Month(BookDate)-Month(Today())) as [Month Diff]

You can see also the attach qvw.