Discussion board where members can get started with QlikView.
I have a requirement where I want to add 2 leading zero if the department is 1 character, if it is 2 character 1 leading zero and if it is 3 leave is as it is.
So From the attached file I need something like this
Any help would be greatly appreciate it.
Try one of these
Num(Dept_No, '000') as Dept_No
Text(Num(Dept_No, '000')) as Dept_No
View solution in original post
Text(IF( Len(Dept_No) <3, Repeat( '0', 3-Len(Dept_No))& Dept_No,Dept_No )) as Dept_No