topic Re: NumWeek 1 newyear vs NumWeek 52 prevyear - how to compare? in QlikView

NumWeek 1 newyear vs NumWeek 52 prevyear - how to compare?

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

Hi, I make a request:
answering some cases about comparisons between weeks I was a doubt.
the expression that seemed useful to me to make that kind of comparison was:
sum ({<NumWeek = {'> = $ (= max (NumWeek) -1) <$ (= max (NumWeek))'}>} Sales) for the previous week and,
sum ({<NumWeek = {'> = $ (= max (NumWeek))'}>} Sales) for the current week.
The question is how to solve the cases in which the year changes being compared to week 1 of the new year, with the 52 of the previous year.

Re: NumWeek 1 newyear vs NumWeek 52 prevyear - how to compare?

Vegar — Tue, 26 Feb 2019 23:59:12 GMT

I would add a week index to my calendar. The first week in the calendar is 1 when you start the next year you let the index be 53 (not 1)

With this week index field you may apply your current set expression logic.

You will of course keep your old week number (1-52) for presentation purposes.

Re: NumWeek 1 newyear vs NumWeek 52 prevyear - how to compare?

tincholiver — Wed, 27 Feb 2019 17:40:08 GMT

I understand, there seems to be no other method to solve this.
Thanks for your answer Vegar.