Discussion Board for collaboration related to QlikView App Development.
If the first 2 letter of a value starts with "X7" then we need to ignore the first two letters and rest has to be considered as the value.
For example, if the value of the field is X7RTXS then we should consider the value as only RTXS. Please help me to achieve this,
X7EGJGF --> EGJGF
X7GWEERY --> GWEERY
if( left( [FieldName],2) = 'X7', mid([FieldName],3), [FieldName] as NewFielName
I think this will work
if(left('FieldName',2)='X7',Mid('FieldName',3)) as Temp
if(left(field,2)='X7', Right(field, len(field)-2), field) as newfield