topic Re: week Number in QlikView

week Number

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

I have requirement, i want to show month wise week number w1,w2,w3,w4,w5

It should be start with Week 1, Week 2... and so on

please see this also..Date Functions

without using any macro....

Example:

Feb Month 2016

Monday	Tuesday	Wednesday	Thursday	Fryday	Saturday	Sunday
25	26	27	28	29	30	31	(Jan)
01	02	03	04	05	06	07	Week number 1
08	09	10	11	12	13	14	Week number 2
15	16	17	18	19	20	21	Week number 3
22	23	24	25	26	27	28	Week number 4
29							Week number 5

Any suggestions ?

Re: week Number

ThornOfCrowns — Fri, 11 Mar 2016 10:42:43 GMT

Presuming that having two week 4's is a typo and borrowing the answer from this question:

Monthly week number !

Try

if((week(Date) - week(monthstart(Date)) + 1)<1,1,(week(Date) - week(monthstart(Date)) + 1)) as WeekNumberInMonth,

Props to philmywallet for the work!

Re: week Number

Nagaraju_KCS — Fri, 11 Mar 2016 10:43:55 GMT

i found in Community..

i have used this code...

if(month(weekend(data))= month(data),div(day(WeekEnd(data)),7),div(day(Weekend(data,-1)),7)+1)+1 as WeekNumber,

But Feb, 2016 it showing start with Week2,week3,week4 and so on.

My requirement it should start with Week1......

Re: week Number

Fri, 11 Mar 2016 10:50:49 GMT

Take Month(DATE) as Month, Weekday(DATE) as Weekday in script... and in report take Month and weekday field as dimension and count(DATE) as expression in chart ...then the report will show the output you want

Re: week Number

CELAMBARASAN — Fri, 11 Mar 2016 11:32:04 GMT

May be you can try the below script

LOAD *, If(Month(Date) = Month(Previous(Date)), if(Week(Date)=Week(Previous(Date)), Peek('WeekNo'), Peek('WeekNo') + 1), 1) AS WeekNo

Resident Calendar;

topic Re: week Number in QlikView

week Number

25

26

27

28

29

30

31

(Jan)

Re: week Number

Re: week Number

Re: week Number

Re: week Number