I want to replace IN and IC from IN020347 and IC236484 from a column in qliksense?
Replace(Replace([User ID], 'IC'), 'IN') AS [User ID]
in the script to remove IN and IC
and if I want to replace In with 74 and IC with 75 then ?
Use the same function a little bit different:
Replace(Replace([User ID], 'IC', 75), 'IN', 74) AS [User ID]
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 ??
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?
I want to arrange this properly.
Then create another field in your data model where each day of the week gets a numeric value you can use to sort
You have to type
in the "Sorting" section, below "Dimensions".
Try to sort by
Replace(s, fromstring ,tostring)
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.
some of them are also small characters not capital like IN and IC they are like in020202 and ic323232
Replace(Replace(Upper([User ID]), 'IC','75'), 'IN','74') AS [User ID]
Thank you so very much bro... thanx alot
Mid([User ID],3,10) as UserID,
Assuming that we have only IC and IN
Retrieving data ...