Discussion board where members can get started with QlikView.
Let's say I have a field with reference numbers.
I would like to keep only the numbers before the first dot (.)
Go to Solution.
Try using the Subfield() function:
Subfield(Test,'.',1) as Extract
View solution in original post
Thank you Stefan
May be try this:
Left(Number, FindOneOf(Number & '.', '.,-')-1) as NewNumber;
LOAD * Inline [
IF(Index(Num,'.')>=1, Subfield(LEFT(Num, Index(Num, '.')), '.'), Num) AS Number;
LOAD * INLINE [