Split part in Qlikview

[#1]

Hi,

I have data something like keerthi(3222).

I need to display Keerthi and 3222 separately.

Please help me with this

Thanks,

Keerthi KS

[Ralf-Narfeldt]

If the field is called Input:

SubField(Input,'(', 1) gives Keerthi

http://help.qlik.com/sense/2.0/en-US/online/#../Subsystems/Hub/Content/Scripting/StringFunctions/Sub...

TextBetween(Input, '(', ')') gives 3222

http://help.qlik.com/sense/2.0/en-US/online/#../Subsystems/Hub/Content/Scripting/StringFunctions/Tex...

[MayilVahanan]

Hi

Try like this

SubField('keerthi(3222)','(',1)

SubField(FieldName,'(',1)

TextBetween('keerthi(3222)','(',')')

TextBetween(FieldName,'(',')')

[PrashantSangle]

Hi,

There is various ways to acheive it.

one way is already suggested by Ralf

another can be

Purgechar(fieldName,'()0123456789') as field1

KeepChar(Purgechar(fieldName,'()'),'0123456789') as field2

Regards

[jagan]

Hi,

You can use SubField() and TextBetween() for this, do this in script for better performance

SubField('keerthi(3222)','(',1)

TextBetween('keerthi(3222)','(',')')

Hope this helps you.

Regards,

Jagan.

[#6]

Hi Jagan,

I have Fiscal Year 2015-16 which should be displayed as a Label for some amount.

There are other Fiscal Years like 2010-11, 2011-12 etc.

By default it should display the latest Fiscal Year i.e 2015-16

[#7]

What if my data is something like Keerthi (Raj) & Kumar (Raj) (2345)

I need to display Keerthi (Raj) & Kumar (Raj) and 2345.

Basically at the there is a number within (  ). I need only that sepaartely

[PrashantSangle]

Hi,

Try

max(Fiscal_Year)

Regards

[#9]

I tried with Max it shows '-'. Because Fiscal year is something like 2015-16 not a number

[sasiparupudi1]

try maxstring(Fiscal_Year)