want to know how to replace?

[#1]

I want to replace IN and IC from IN020347 and IC236484 from a column in qliksense?

User ID

IN125417

IC017803

IC017803

[#2]

Try

Replace(Replace(Upper([User ID]), 'IC','75'), 'IN','74') AS [User ID]

[#3]

Thank you so very much bro... thanx alot

[Miguel_Angel_Baeyens]

Ok,

Then create another field in your data model where each day of the week gets a numeric value you can use to sort

Miguel

[#5]

You have to type

num(WeekDay(YourDateField))

in the "Sorting" section, below "Dimensions".

[robert_mika]

Why not

Mid([User ID],3,10) as UserID,

Assuming that we have only IC and IN