Customize week start from Any WeekDay

    Hi Qlikers,

     

    This Blog deals with a very simple requirement of customizing week start as per business requirement.

    Like in attached example we had a Business need to have week numbers to start from Wednesday.

    This can be done by modifying FirstWeekDay in SET statement.

    SET FirstWeekDay=2; // this will set week to start from Wednesday.


    Customize Week Upload.PNG

    You can customize your week with any week start day.