topic Re: Week calculation in QlikView

Week calculation

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

Hi Community,

Week numbers are often used in calendar, we can create simple way WEEK(DATE) i.e 52/53 weeks.

I'm facing issue with Week level data, my users wants to show like below

Week 1

Week 2

Week 3

Week 4

Jan Week 5

Feb Week 5

Week 6

Week 7

Week 8

Feb Week 9

Mar Week 9

Week 1 to Week 4 under Jan month, but Week 5 is both in Jan and Feb... so it is not taking correct value.

I want Bifurcate 2 levels, like Jan Week 5 and Feb Week 5 and so on...

Any possibility??

Experts please suggest any better way....

Thanks in Advance!!

eduardo_dimperio — Wed, 23 May 2018 18:48:29 GMT

Is mandatory that your filter uses weeks?

Anil_Babu_Samineni — Thu, 24 May 2018 03:20:53 GMT

Not sure about your user needed. As i ma user, This is not make sense to me. If you select week 5 then what data will come up to the picture.

ogautier62 — Thu, 24 May 2018 09:12:45 GMT

Hi,

use as dimension :

Month() + week()

regards