Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Gowtham174
Creator
Creator

How to create Week number starting from Jun 2018

Hi All,

Please help me to create fiscal week number staring from Jun 2018

29-06-2018  to 05-07-2018 -start Week (Week 1)

.

.

.

.

27-06-2019 to 27-06-2019 - end Week (Week 52)

Thanks,

Gowtham

2 Replies
sibin_jacob
Creator III
Creator III

Please use the below script,

I have added only for few dates.

test:

load * inline [

Date_value

29-06-2018

30-06-2018

01-07-2018

02-07-2018

03-07-2018

04-07-2018

05-07-2018

06-07-2018

07-07-2018

08-07-2018

09-07-2018

10-07-2018

11-07-2018

12-07-2018

13-07-2018

14-07-2018

15-07-2018

16-07-2018

];

test1:

Load Date_value, 'Week ' & (floor((RowNo()/7)-.01)+1) as Week_Number

Resident test;

Drop table test;

renuka_sasikumar
Creator III
Creator III

Hi,

You can try this, Hope this help

Regards,

Renuka S