Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how to do:
from ert234.55, 342er.345 or TRW345.12345 get string before .
so i want ert234, 342er , TRW345 and so on.
In a load statement in a load script:
LOAD
SubField( aField , '.' , 1 ) AS BeforeDot
.....
FROM
.....;
In the application:
=SubField( aField, '.' , 1 ) in an expression in a chart
Or if you have the strings in variables:
=SubField( aVar , '.', 1 )
Use the function SubField(text, N) and set N=1
cheers,
Oleg Troyansky
QlikView Your Business: An expert guide to Business Discovery with QlikView and Qlik Sense
In a load statement in a load script:
LOAD
SubField( aField , '.' , 1 ) AS BeforeDot
.....
FROM
.....;
In the application:
=SubField( aField, '.' , 1 ) in an expression in a chart
Or if you have the strings in variables:
=SubField( aVar , '.', 1 )
see attached.