topic Qlik Scripting Issue in QlikView

Qlik Scripting Issue

Thu, 28 Jul 2016 16:28:56 GMT

Hi, so I was wondering if anyone could provide an idea of how to implement the following in qlikview?

IF brackets in value string, then create a subfield of string within the brackets AS newValue

ELSE create a subfield of 1st 4 characters in value string AS newValue

Thanks, Ben

sunny_talwar — Thu, 28 Jul 2016 16:56:13 GMT

May be like this:

If(Index(string, '(') and Index(string, ')'), TextBetween(String, '(', ')'), Left(String, 4)) as NewValue

Update: Missed a parenthesis

vishsaggi — Thu, 28 Jul 2016 16:56:58 GMT

Can you post some sample data and expected output if possible??