topic Re: Add week in QlikView

Add week

stephenedberkg — Wed, 25 Nov 2020 16:16:04 GMT

I have the week format like this

12-50-2016

i want to add this week to 2.

tresB — Fri, 01 Apr 2016 07:01:49 GMT

12 is month? 50 is week? How do you derive/interpret this week format?

jonathandienst — Fri, 01 Apr 2016 07:04:55 GMT

I suggest that you give some more examples and explain what you expect the week to be.

stephenedberkg — Fri, 01 Apr 2016 10:43:05 GMT

my date format is

MM-W-YYYY

11-46-2016

11-47-2016

each id have different lock period i want to add the lock period into week

if my lock perios is 1

i want like this

11-47-2016

11-48-2016

i am using mapping function

InvoiceDate + ( ApplyMap('LockPeriods',ID,'Not matching')) as INV_Lock,

11-47-2016 + 1

tresB — Fri, 01 Apr 2016 10:59:25 GMT

Try something like like:

MakeWeekDate(SubField(InvoiceDate, '-',3), SubField(InvoiceDate, '-',2) + ApplyMap('LockPeriods',ID) ) as INV_Lock_Date,

Fri, 01 Apr 2016 11:27:05 GMT

Hi Stephen,

Can you please see the below script. You will get the desired value.

input:

load * inline [

date

11-46-2016

11-47-2016

];

oo:

load SubField(date,'-',1)&'-'&RangeSum(SubField(date,'-',2),1) & '-'&SubField(date,'-',3) as ss

Resident input;

Thanks,
Sreeman.

stephenedberkg — Fri, 01 Apr 2016 11:40:01 GMT

I tried but i cant get any values