Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Default Fiscal Year Start Date to Date field

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.

0 Replies