Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello , im new to this qliksense , i want to ask is it possible to take the first and last element from string ?
if C# we can do like string.Split('delimiter').First() / string.Split('delimiter').Last()
how about in qliksense?
example data:
Full name
1. Andy Robertson Jason Expected Result : First : Andy, Last : Jason
2. Bernard Andy Robertson Jason Expected Result : First : Bernard , Last : Jason
In Qlik, We can write like
SubField(FullName, ' ', 1) as FirstName
SubField(FullName, ' ', -1) as LastName
In Qlik, We can write like
SubField(FullName, ' ', 1) as FirstName
SubField(FullName, ' ', -1) as LastName
Thankyou ! it works