topic Difference between weeks in a variable in QlikView

Difference between weeks in a variable

lbunnell — Mon, 25 Jul 2016 17:21:39 GMT

Does anyone know how I convert the answer in this post number of months in a variable to the number of weeks?

Clever_Anjos — Mon, 25 Jul 2016 17:29:53 GMT

Maybe

Floor( ( D2 - D1 ) / 7 )

deniscamh — Tue, 29 Nov 2016 16:21:23 GMT

Hi Lawrence,

Try this:

SET WeekDiff = Num(((year($2) * 52) + (month($2)*7)+ week($2)) - (((year($1) * 52) + (month($1)*7)+week($1))));