Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
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..