WeekNum

[MK_QSL]

How to get week numbers from date considering

Week Starts from Saturday...

Week Starts from Sunday..

Week Starts from Monday

Need for all three..

[tresesco]

Try:

Week(WeekStart(YourDate,6))  // starts Saturday

Week(WeekStart(YourDate,7))  // starts Sunday

Week(WeekStart(YourDate))  // starts Monday  , in fact simply week(Yourdate) should work

[hic · Accepted solution]

Se the script at the bottom of http://community.qlik.com/blogs/qlikviewdesignblog/2012/10/23/ancient-gods

HIC

[MK_QSL]

Dear Henric,

Excellent blog... Thanks for your help.