Discussion Board for collaboration on QlikView Layout & Visualizations.
I have a requirement in which I need to purge character of a field value if the first character is an Alphabet.
May be this
If(IsText(Left(Input, 1)), Mid(Input, 2), Input)
View solution in original post
If(IsText(Left(Input, 1)), Mid(Input, 2), Input) as DesiredOutput;
LOAD * INLINE [
Thank you.. Works Perfectly.