Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
driplpent
Contributor
Contributor

Help Adding Underscore At End of Number

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?

1 Reply
AshutoshBhumkar
Partner - Specialist
Partner - Specialist

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 :

AshutoshBhumkar_0-1642230401493.png

 

Thanks,
Ashutosh