Populate day number in wek

[Karim_Khan]

Hi Team,

    Normally weeks starts from Mon,Tue,Wed,Thur,Fri,Sat...Sunday.and day numbers shows as 0,1,2,3,4,5,6 respectively.

In my case week is getting started from Sunday and ends at Saturday

      Sun,Mon,Tue,Wed,Thur,Fri,Sat and day number should show like 1,2,3,4,5,6,7

I was trying to change the start day of week but wrong data is getting populated

Regards,

KK

kush141087‌sureshqv‌stalwar1‌

[Kushal_Chawda]

see this

Custom weekly calendar creation - how to?

Qlik Design Blog : Redefining the Week Numbers | Qlik Community

[sujeetsingh]

Follow this

Fiscal Year

[Karim_Khan]

Kush,

    I wanted to set Sunday as 1 not start from 0

[Kushal_Chawda · Accepted solution]

That, you can customized by simple if, if(WeekNo=0,1,if(weeNo=1,2  ...

or create mapping table

LOAD * inline [

WeekNo, WeekNoNeeded

0,1

1,2

2,3

3,4

4,5

5,6

6,7 ];

[Anonymous]

Hi karim,

Do you wanna this?

     Week(Date - 6)

     WeekDay(Date - 6)

Regards

[Colin-Albert]

This blog shows how to change the start day of your week.

Redefining the Week Start

[Karim_Khan]

I got the solution by applying Inline table thanks for ur revert

[Karim_Khan]

Kush, 

   As we done the week day number calculation in morning it is working fine.But now problem is arising like week end date is taking wrong date