topic Re: Need help with what function to use in QlikView

Need help with what function to use

has75042 — Wed, 25 Nov 2020 16:16:04 GMT

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

000,002,003,004....012,013,014....104,108

Any help would be greatly appreciate it.

Re: Need help with what function to use

sunny_talwar — Wed, 16 Jan 2019 17:24:07 GMT

Try one of these

Num(Dept_No, '000') as Dept_No

Text(Num(Dept_No, '000')) as Dept_No

Re: Need help with what function to use

vamsee — Wed, 16 Jan 2019 17:38:25 GMT

Try

Text(IF( Len(Dept_No) <3, Repeat( '0', 3-Len(Dept_No))& Dept_No,Dept_No )) as Dept_No