Transform W201613 to Week number like 13

[0li5a3a]

Hi,

Does anyone know if I can transform in a Line Chart / Dimension the week format from W201613 to 13?

Regards,

C

[0li5a3a]

Please ignore my preview replay. I tried now in the dimension and the AddWeeks highlighted with red and all the function after this they are not colored in blue...  I think the syntax is wrong

Please find below:

[zhadrakas]

just typed this Expression without testing. There is no addweeks function in QlikView

try to use addmonths instead (-4 shoud be equivalent to 16 weeks)

=if(CalendarPeriodnum>= num(WeekStart(AddMonths(max(CalendarPeriod),-4)))
AND CalendarPeriodnum <= num(WeekEnd(max(CalendarPeriod))), DATE#(date#(RIGHT(OP.YrWeek,2))))

[Anonymous]

Use something like : right(Week,2)

[0li5a3a]

I used this and all the data just gone....

=if(CalendarPeriodnum>= num(WeekStart(AddMonths(max(CalendarPeriod),-4))) AND CalendarPeriodnum <= num(WeekEnd(max(CalendarPeriod))), DATE#(date#(RIGHT(OP.YrWeek,2)))). Is an error into dimension formula