topic Re: Leading Zero for Calendarweeks in QlikView

Leading Zero for Calendarweeks

chriys1337 — Thu, 08 Feb 2018 10:15:01 GMT

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!

tresB — Thu, 08 Feb 2018 10:19:34 GMT

Try like:

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

chriys1337 — Thu, 08 Feb 2018 10:45:06 GMT

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