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

[Miguel_Angel_Baeyens]

‌Hi Sid,

Use

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

in the script to remove IN and IC

Miguel

[#3]

hello,

and if I want to replace In with 74 and IC with 75 then ?

[Miguel_Angel_Baeyens · Accepted solution]

Use the same function a little bit different:

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

Miguel

[#5]

Hi,

Syntax :

Replace(s, fromstring ,tostring)

i.e. :

Replace('abccde','cc','xyz') will return 'abxyzde'

Let's try :

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

Attention, replace() is maybe case sensitive.

Xavier.

[#6]

Hello,

again a query I want to arrange weekday from mon to sunday properly as I have downloaded horizontal check box template I dun have sorting option in It so any Expression we can pass ??

[Miguel_Angel_Baeyens]

Sid,

I'd recommend you to create a different thread with your new question and provide some pictures or examples of what you have and where do you want to get.

When you mean arrange do you mean showing in a chart from Monday to Sunday? Or in the load script?

Miguel

[#8]

Try to sort by

=num(WeekDay(YourDate))

[#9]

I want to arrange this properly.

[#10]

some of them are also small characters not capital like IN and IC they are like in020202 and ic323232