Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Try like:
Num(Week(Date),'00') as TwoDigitWeek
Thank you, I tried it with num(Week(date),'##') but this did not work....