Need logic help to creation weeks.

[lalitkgehlot89]

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

[teiswamsler]

Hi lalit

Try take a look at this post

https://community.qlik.com/docs/DOC-7094

/Teis

[Anonymous]

On script, to calculate fiscal week:

Week(Addmonts(FiscalDate,-3)) //Only Week Number

WeekName(Addmonths(FiscalDate,-3)) //Week - Year

Reagards!

[Anil_Babu_Samineni]

Perhaps this from script level

Week(Date(AddMonths(MonthStart(Today(),0),-5),'DD-MMM-YYYY')) as WeekFromApril,

.......

[Anonymous]

Please go through the below post. Similar question is posted and answered

Fiscal Weeks (Week Numbers) | Qlik Community

Hope this helps.