Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikwiz123
Creator III
Creator III

Remove characters before :

I have Column - Data that has values in the format below

 

10/25/2015 : Agent1: This is the right value

05/11/2017 : Agent 56: Please change the report

I need to remove everything before the second ':' and only show the text in my output.

This is the right value
Please change the report

 

How do I do this in the expression or Script? I tried =Mid(Data, Index(Data, ': ')+2) but this only removes text before the first ':'

Labels (2)
10 Replies
qlikwiz123
Creator III
Creator III
Author

This is more dynamic since I don't have to mention the string 'Agent' as this is not constant. Thank you