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

Announcements
Save an extra $150 Dec 1–7 with code CYBERWEEK - stackable with early bird savings: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
El_Davidus
Contributor II
Contributor II

how can I add '_' to my column's variables so I can always have exactly 149 characters ?

Hello everybody.

Here is an example of what I want to do. 

Capturar.PNG

 

Is this possible?

 

Labels (1)
1 Solution

Accepted Solutions
Qlik1_User1
Specialist
Specialist

Try this..

Name 2: Repeat('_',(149-LEN(Name)))&Name

View solution in original post

1 Reply
Qlik1_User1
Specialist
Specialist

Try this..

Name 2: Repeat('_',(149-LEN(Name)))&Name