Time

[NavinReddy]

Hi All,

Some one help me

current week Sunday- saturday using system time

thanks in advance,

rohith

[NavinReddy]

Hi vishwa,

These two expression not working for me

thanks,

rohith

[hic]

If you want to define week numbers and week days using Sunday as the first day of the week, you have to write your own expressions.

One way to do it is the following

Load *,

          Dual(WeekDay(Date),Mod(WeekDay(Date-$(vFirstWeekdayOfWeek)),7)) as WeekDay,

          Ceil((Date-FirstDateOfWeekOne+1)/7) as WeekNumber,

          Date(WeekStart(Date-$(vFirstWeekdayOfWeek))+$(vFirstWeekdayOfWeek)) as WeekStart;

Load *,

          Date(

               WeekStart(YearStart(Date)+$(vMinDaysInWeek)-$(vFirstWeekdayOfWeek)-1)

               +$(vFirstWeekdayOfWeek)) as FirstDateOfWeekOne,

See more on http://community.qlik.com/blogs/qlikviewdesignblog/2012/10/23/ancient-gods

HIC