Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikviewforum
Creator II
Creator II

If the value starts with X7 ignore it consider rest of the letters

Hi,

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

3 Replies
JonnyPoole
Employee
Employee

load

     if( left( [FieldName],2) = 'X7', mid([FieldName],3), [FieldName] as NewFielName

from

<source>

qlikviewforum
Creator II
Creator II
Author

I think this will work

if(left('FieldName',2)='X7',Mid('FieldName',3)) as Temp

maxgro
MVP
MVP

if(left(field,2)='X7', Right(field, len(field)-2), field) as newfield