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

Help Adding Underscore At End of Number

driplpent — Sat, 15 Jan 2022 06:46:41 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

AshutoshBhumkar — Sat, 15 Jan 2022 07:08:02 GMT

Hello,

Yes, you are right. Just append the underscore at the end of the dimension. (This will just convert your dimension format from number to text)

[Account Number]&'_'

E.g :

Thanks,
Ashutosh