Discussion board where members can get started with Qlik Sense.
Can any one please help me on below issue.
I have a Name Field like below, from the Name field please help me to get the Expected Name output field
Wholesale Market [ 239801]
Risk Control Server [ 1234567]
Expected Name output
Risk Control Server
Thanks in advance
View solution in original post
Another way to use LEFT() with INDEX() string functions. See below. Minus 2 is to eliminate the "WHITE SPACE"
& "[" characters.
Maybe like this
SubField('Risk Control Server [ 1234567]','[',1)