Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
janus2021
Contributor III
Contributor III

Insert/add or concat a new value into a string

Hi.
If I have a parameter that comes with values ​​like: '5501', '6209','7812 ','9933' I would like to copy a number type 10. The parameter can contain dynamic number of numbers but the format is always the same.
The parameter before: vParam = '5501', '6209','7812','9933'; parameter after editing: vParam = '105501', '106209', '107812', '109933';

i have tried: set vRepl=Replace($(vParam),''',''20');
but it doesnt work.

any ideas?
Labels (3)
3 Replies
Chanty4u
MVP
MVP

Not sure with your expected output 

try this

set vRepl='10'&($(vParam);

 

Kashyap_R
Partner - Specialist
Partner - Specialist

Hi 

I think we cant use Replace for variable because u r passing so many values in single variable and replace treats it as separate field instead of that use that as inline load or as a field then you can use replace function.

If u want the values in single variable u can create in front end by using below expression

chr(39) & field &chr(39)&chr(44)

hope you understand

Thanks and regards

Kashyap.R

Thanks and Regards
Kashyap.R
janus2021
Contributor III
Contributor III
Author

Srry but it didnt work.