Leading Zero for Calendarweeks

[chriys1337]

Hi all,

I am generating a Year & Calendarweek Field with the help of my date field

From week 1-9 the leading Zero is missing, which I need and I am adding it artificially with following expression:

weekYear(Date) & if(len(Week(Date))=1,0 & Week(Date),Week(Date) )) as Year_Week

Now I wonder, if there is a better way to force QlikView to put a leading Zero to the Week String?

Thanks for your help!

[tresesco · Accepted solution]

Try like:

Num(Week(Date),'00') as TwoDigitWeek

[chriys1337]

Thank you, I tried it with num(Week(date),'##') but this did not work....