topic Re: Automate variable. in QlikView

Automate variable.

rupaliqlik — Thu, 07 Jul 2016 15:33:03 GMT

Hi Expert,

I want to create two variables in my qvw .where vStartDate must be start date of financial year and end date must be last date of that fin year.i want to automate this two variable .Means next year they must change.

For e.g

Let vStartDate=Makedate(2016,04,01);// next year 01/04/2017

Let vEndDate=Makedate(2017,03,31);//31,03,2018

Please help me

Regards,

Rupali

Re: Automate variable.

boorgura — Thu, 07 Jul 2016 15:51:37 GMT

LET vYear = year(today());

Let vStartDate=Makedate('$(vYear)',04,01);// next year 01/04/2017

Let vEndDate=Makedate('$(vYear)',03,31);//31,03,2018

Re: Automate variable.

Peter_Cammaert — Thu, 07 Jul 2016 15:55:36 GMT

You mean, you want the script to figure out whether we're in the current or in the next fiscal year?

Something like this?

Let vStartDate = Makedate(IF (Month(Today())<4,Year(Today())-1,Year(Today())),4,1);

Let vEndDate = Makedate(IF (Month(Today())<4,Year(Today()),Year(Today())+1),3,31);

Best,

Peter;

Re: Automate variable.

rupaliqlik — Thu, 07 Jul 2016 16:00:22 GMT

Thank you!

but i was trying like this.

vStartDate=Date(Makedate(Left(Yearname(Date(Today(),'DD/MM/YYYY'),0,4),4),04,01),'DD-MMM-YYYY')

Re: Automate variable.

Peter_Cammaert — Thu, 07 Jul 2016 16:02:19 GMT

You can also use Rakesh's technique, but with one correction:

Let vTodaysYear = Year(Today());

Let vStartDate = Makedate(IF (Month(Today())<4,vTodaysYear-1,vTodaysYear),4,1);

Let vEndDate = Makedate(IF (Month(Today())<4,vTodaysYear,vTodaysYear+1),3,31);

Best,

Peter

Re: Automate variable.

Peter_Cammaert — Thu, 07 Jul 2016 21:17:29 GMT

Do you think that's more readable?