Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

gowtham174
New Contributor III

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
Contributor III

Re: How to create Week number starting from Jun 2018

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
Contributor III

Re: How to create Week number starting from Jun 2018

Hi,

You can try this, Hope this help

Regards,

Renuka S