topic Change a Field in QlikView

Change a Field

evansabres — Wed, 30 Dec 2015 14:39:44 GMT

Hello -

I have a field called [Act Name} which appears as Home Team VS. Other Team

I want to only show VS. Other Team. Home Team is always the same number of characters, what is the best way to do this?

Thank you.

sunny_talwar — Wed, 30 Dec 2015 14:42:30 GMT

May be this:

'VS. ' & SubField([Act Name], 'VS.', 2) as FieldName

MarcoWedel — Wed, 30 Dec 2015 14:50:32 GMT

Mid([Act Name],11) as [Act Name]

regards

Marco