topic Re: Need logic help to creation weeks. in QlikView

Need logic help to creation weeks.

lalitkgehlot89 — Wed, 25 Nov 2020 16:16:04 GMT

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 — Mon, 26 Sep 2016 11:26:15 GMT

Hi lalit

Try take a look at this post

/Teis

Anonymous — Mon, 26 Sep 2016 11:34:18 GMT

On script, to calculate fiscal week:

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

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

Reagards!

Anil_Babu_Samineni — Mon, 26 Sep 2016 11:40:21 GMT

Perhaps this from script level

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

.......

Anonymous — Mon, 26 Sep 2016 11:47:04 GMT

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

Hope this helps.