topic Removing prefix from expression in QlikView

Removing prefix from expression

Mon, 17 Oct 2011 08:22:41 GMT

Hello,

I have a dimension with the following expression:

Arrangement

now how this comes out in the chart is such as this:

023 Hotel services

4122 Flight services

482a Transport services

My question is, how should I edit the expression to remove the numbers, letters and the empty space in front of the arrangement names? All names have a three to four character prefix with numbers, but the fourth character can be a letter. To get a result like this:

Hotel services

Flight services

Transport services

Many Thanks!

Removing prefix from expression

Anonymous — Mon, 17 Oct 2011 08:30:30 GMT

Try this:

LOAD

Mid([Arrangement], (Index([Arrangement], ' ', 1) + 1)) as [Arrangement]

...

Removing prefix from expression

Mon, 17 Oct 2011 08:36:36 GMT

Hi,

You can use the next expression:

=mid(Arrangement,findoneof(Arrangement,' ')+1,len(Arrangement)-findoneof(Arrangement,' '))

Succes!

Removing prefix from expression

SunilChauhan — Mon, 17 Oct 2011 08:53:54 GMT

use one of below

subfield(yourfieldname,' ',2) as yournewfieldname in script or

subfield(yourfieldname,' ',2) in expression

subfield(yourfieldname,' ',2) in calculated dimension