Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
In my data I have fiscal Month, Fiscal Year, fiscal date also.
here i want to create a chart of weekly sales but problem is that week should be from 1 April in place of 1 January.
first week should be in April and last week should be in March Month of the same fiscal year(Apr-Mar).
Please help me out to create the logic.
Regards,
Lalit Kumar
On script, to calculate fiscal week:
Week(Addmonts(FiscalDate,-3)) //Only Week Number
WeekName(Addmonths(FiscalDate,-3)) //Week - Year
Reagards!
Perhaps this from script level
Week(Date(AddMonths(MonthStart(Today(),0),-5),'DD-MMM-YYYY')) as WeekFromApril,
.......
Please go through the below post. Similar question is posted and answered
Fiscal Weeks (Week Numbers) | Qlik Community
Hope this helps.