Hi Friends,
I have requirement to Set Date field as Fiscal year start date, say as for current Financial year Set Date field to 11/1/2016[1st Nov 2016]
and if sysdate >=1st Nov 2017 & <=31st Oct 2017, set to Start Date as 11/1/2017
and if sysdate >=1st Nov 2018 & <=31st Oct 2018, set to Start Date as 11/1/2018
and so on.
Request you please give some pointers in Qlikview to achive.
Thanks in advance.
