Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
durgabhavani
Creator III
Creator III

Help me to concat the value.

Hi

I have id's like below.

ID

1235

3456

2346

2345

1234

9870

7890

I want to concatenate .5 at the end of each id. Please find expected output below.

Expected Output

ID

1235.5

3456.5

2346.5

2345.5

1234.5

9870.5

7890.5

1 Solution

Accepted Solutions
sunny_talwar

May be this

ID & '.5' as ID

or this

ID + 0.5 as ID

View solution in original post

2 Replies
sunny_talwar

May be this

ID & '.5' as ID

or this

ID + 0.5 as ID

durgabhavani
Creator III
Creator III
Author

& working fine. Thanks Sunny..