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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
janus2021
Creator
Creator

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
Creator
Creator
Author

Srry but it didnt work.