topic Re: Filter from filed. in QlikView

Filter from filed.

sona_sa — Fri, 10 Jul 2015 03:51:36 GMT

Hi,

I have a field. In the same filed date are like that :

CONSULTANCY - AFFILIATES (AFF002)

DT GROUP NAV-PROD (708.8677)

AUSTRALIA - NAV (PRJ001)

I Need only which are enclosed in braces. For Example :

CONSULTANCY - AFFILIATES (AFF002) = AFF002

DT GROUP NAV-PROD (708.8677) = 708.8677

AUSTRALIA - NAV (PRJ001) = PRJ001

Can anyone help me on the same.

Thanks.

MayilVahanan — Fri, 10 Jul 2015 03:57:42 GMT

Try like this

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

TextBetween(' CONSULTANCY - AFFILIATES (AFF002)','(',')')

Fri, 10 Jul 2015 04:00:01 GMT

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

Regards,

KKR

arulsettu — Fri, 10 Jul 2015 04:02:05 GMT

try this too

=PurgeChar(SubField('CONSULTANCY - AFFILIATES (AFF002)','(',2),'()')

qlikviewwizard — Fri, 10 Jul 2015 04:15:59 GMT

Hi , MayilVahanan and arulsettu answers are working fine.

Filter_Data:

LOAD *, TextBetween(FIELD, '(',')') as TextBetween_FIELD,

PurgeChar(SubField(FIELD,'(',2),'()') as PurgeChar_FIELD;

LOAD * INLINE [

FIELD

CONSULTANCY - AFFILIATES (AFF002)

DT GROUP NAV-PROD (708.8677)

AUSTRALIA - NAV (PRJ001)

];

Fri, 10 Jul 2015 04:42:17 GMT

Hi,

Please find the attached QVW.