Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
evansabres
Valued Contributor

Change a Field

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.

2 Replies
Highlighted

Re: Change a Field

May be this:

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

Highlighted

Re: Change a Field

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


regards


Marco