Discussion board where members can get started with Qlik Sense.
I have strings like below in a column.
how can i exclude the first letter while loading the data.
Go to Solution.
what is this 'abcdefghijklmnopqrstuvwxyz'
In my case, i just want to remove the first word
will not work as this will remove all numeric and uppercase characters leaving lowercase characters only- all data in Qlik is case sensitive.
tT exclude the first character, use mid()
mid(FieldName, 2) will return everything in the field from the 2nd character.