topic Re: How to enter current week as two digits in a string in QlikView

How to enter current week as two digits in a string

Anonymous — Thu, 04 Jan 2018 09:50:22 GMT

Hello,

I have a script where I need to enter the current year and week as fields. The problem is that I need to enter the current week as two digits (08, 09, 10, 11 etc), but now it enters the week as 8, 9, 10, 11 so the end result for this week is 20181 and not 201801.

Is there any way to set the week standard value as XX and not X?

My script now:

vWeek=Year(now())&week((now()))

AUTOSTOCK:

LOAD

DEAL AS [DEALER],

PRIS AS PRICE,

$(vWeek) AS Week;

SQL SELECT *

FROM ......

Thank you

Re: How to enter current week as two digits in a string

tresB — Thu, 04 Jan 2018 09:52:22 GMT

Try like:

vWeek=Year(now())& Num( week((now())), '00')

Re: How to enter current week as two digits in a string

mdmukramali — Thu, 04 Jan 2018 09:54:20 GMT

Hi,

vWeek=Year(now())&Num(week((now())),'00')

vWeek=Year(now())&Num(week(now()),'00')

Re: How to enter current week as two digits in a string

Anonymous — Thu, 04 Jan 2018 10:31:10 GMT

Thank you for the quick response. It worked like a charm!

Do you also know if it is possible to write it as last week so it shows 201752? That is current week minus 1 week.

Re: How to enter current week as two digits in a string

tresB — Thu, 04 Jan 2018 10:35:53 GMT

This?

vWeek=Year(now())& Num( week((Today()-7)), '00')

Re: How to enter current week as two digits in a string

tresB — Thu, 04 Jan 2018 10:45:02 GMT

A better solution could be: =Purgechar(Weekname(today(),-1),'/')

Re: How to enter current week as two digits in a string

Anonymous — Thu, 04 Jan 2018 11:33:04 GMT

Beautiful! Works like a charm.

Thank you very much!