topic Re: last Fiscal Week in QlikView

last Fiscal Week

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

i am trying to get the last week's fiscal week

So for

Fiscal Year Week 2017-26,

i should get

Fiscal Year Week =2017-25

I cant simply write an expression Fiscal Year Week -1

Anil_Babu_Samineni — Thu, 31 Aug 2017 12:55:59 GMT

How you are getting 2017-26 ??

bobbydave — Thu, 31 Aug 2017 12:57:05 GMT

From my calendar

bobbydave — Thu, 31 Aug 2017 12:58:09 GMT

Doesnt necessarily have to be 2017-26

Could be 2017-02

Anil_Babu_Samineni — Thu, 31 Aug 2017 13:00:02 GMT

I know that, I am expecting how you are getting 26 week? Does your fiscal start from Which month? May be share application / script?

bobbydave — Thu, 31 Aug 2017 13:01:55 GMT

I just made up the example of 2017-26

It could be 2016-04 from my T_Calendar.qvd

Anil_Babu_Samineni — Thu, 31 Aug 2017 13:04:23 GMT

I am sorry to say - Question not clear. May be better explain each line and show some sample data set and that demonstrates the issue?

bobbydave — Thu, 31 Aug 2017 13:07:54 GMT

So What I want to do is to get Fiscal Year Week to show me the previous week

So 2016-30 would show 2016-29

Anil_Babu_Samineni — Thu, 31 Aug 2017 13:14:40 GMT

If you need that, Don't use Direct function to get that value

WeekName(DateField) as Fiscal_WeekName

You can use something like below

Year(DateField) & '-' & Week(DateField)-1 as Fiscal_WeekName