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

Help Adding Underscore At End of Number

sirikonta — Mon, 26 Jan 2026 21:26:37 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

anat — Sat, 22 Jan 2022 08:06:07 GMT

load *,val&chr(95) as newfield;
load * inline [
dt,val
2014,14
2015,18
2016,11
2017,12
2018,20
2019,21
];

exit script;

Re: Help Adding Underscore At End of Number

Vegar — Sun, 23 Jan 2022 07:47:49 GMT

The solution above by @anat should work.

When using " " QlikView expects a field name, but when using ' ' QlikView expects a string

The syntax below will also get you the desired output.

AccountNumber & '_'