topic how to in QlikView

how to

rdsuperlike — Mon, 31 Aug 2015 19:43:21 GMT

how to do:

from ert234.55, 342er.345 or TRW345.12345 get string before .

so i want ert234, 342er , TRW345 and so on.

Oleg_Troyansky — Mon, 31 Aug 2015 19:51:34 GMT

Use the function SubField(text, N) and set N=1

cheers,

Oleg Troyansky

petter — Mon, 31 Aug 2015 19:53:20 GMT

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 )

Qrishna — Mon, 31 Aug 2015 20:18:56 GMT

see attached.