topic Variable Month in function Inmonth in QlikView

Variable Month in function Inmonth

sculptorlv — Mon, 01 Feb 2016 13:46:25 GMT

Hello!

I usually use great function InMonth:

InMonth ( date, basedate , shift )

And now I have problem, because I need to use this function again, but I don't have a 'basedate' ... I have only variable with MONTH (not full date)

How can I put this variable .. let say vMonth .. into this function or which another function I can use for the same result??

Thank you.

sunny_talwar — Mon, 01 Feb 2016 13:49:28 GMT

May be create an imaginary date from your Month:

MakeDate(Year(Today()), MONTH) as BaseDate

and then use this in the preceding load:

InMonth(date, BaseDate, shift)

sculptorlv — Mon, 01 Feb 2016 13:56:56 GMT

Thank you