topic Re: Help Adding Underscore At End of Number in QlikView

Help Adding Underscore At End of Number

markel580 — Sun, 05 Jun 2022 17:40:08 GMT

Hi, I have a set of account numbers that I need to add an underscore to the end of, so 1234 to show as 1234_ I recall doing this a while ago but cannot remember how, I know it ended & "_" as .... but cannot remember? I've look online, but cannot find the solution? Any suggestions please?

Re: Help Adding Underscore At End of Number

mikaelsc — Sun, 05 Jun 2022 18:07:57 GMT

"field" & '_' as "NewFieldName"

single quotes for text values... double quotes for fieldnames

Re: Help Adding Underscore At End of Number

MarcoWedel — Sun, 05 Jun 2022 19:06:27 GMT

Num(AccountNo,'0_')

Re: Help Adding Underscore At End of Number

MarcoWedel — Sun, 05 Jun 2022 19:07:08 GMT

also possible:

Dual(AccountNo&'_',AccountNo)