topic Re: Week number showing wrong in QlikView

Week number showing wrong

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

Hi,

We have used the below logic to define week ,but it is not showing correct like if we select 2016 May 1st means it should show 1st week of the month but it showing 2nd week as below

Logic Used : if(month(weekend(new_order_date,0,6))= month(new_order_date),div(day(WeekEnd(new_order_date,0,6)),7),div(day(Weekend(new_order_date,-1,6)),7)) as WeekNumber

Current o/p:

Thanks..

Re: Week number showing wrong

ramasaisaksoft — Tue, 10 May 2016 10:57:33 GMT

Hi Naresh,

we are unable to see your data(Field data which you have in Scripts new_order_date) so please show sample data for that .and check if u select any other month 1st day how is the behavior of that week filter?

Re: Week number showing wrong

nareshthavidishetty — Tue, 10 May 2016 11:04:00 GMT

Thanks for response..

We have resolve the issue using ' 'W'&Ceil(Day(Date)/7) as MonthlyWeek'

Thanks..