topic Variable Creation in QlikView

Variable Creation

upaliwije — Thu, 13 Dec 2018 17:00:10 GMT

Dear Friends

I have created two variable as follows

Let v1=Date(Makedate(2017,12,01),'MMM-YYYY'); out put = Dec-2017
Let v2=Date(addmonths(Makedate($(v1)),1),'MMM-YYYY'); No out put Expected output =Jan-2018

In my 2nd variable I do not get any out put. But my expected output is Jan-2018. Pls help me to get it correct

Re: Variable Creation

sunny_talwar — Thu, 13 Dec 2018 17:04:34 GMT

Try this for the 2nd variable

Let v2 = Date(AddMonths(Date#('$(v1)', 'MMM-YYYY'),1), 'MMM-YYYY');

Re: Variable Creation

upaliwije — Thu, 13 Dec 2018 17:09:30 GMT

Thanks Sunny for your prompt reply.

I could get your advice after a some time