Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
abhaytrip
Creator
Creator

SELECTION OF STRING

Hi all,

As im new to Qlikview , im facing this issue where in i need , if my middle character matches to 2 it goes to F1 and likewise if it matches to 4 it goes to F2.

Please refer the image for better understanding.

ive been trying it for quite sometime , thought of asking out here as well.

thanks.SNIP1.PNG

 

1 Solution

Accepted Solutions
mrybalko
Creator II
Creator II

LOAD
 if(mid(FIELD, 2, 1) = 2, FIELD) as F1,
 if(mid(FIELD, 2, 1) = 4, FIELD) as F2,
...

View solution in original post

2 Replies
mrybalko
Creator II
Creator II

LOAD
 if(mid(FIELD, 2, 1) = 2, FIELD) as F1,
 if(mid(FIELD, 2, 1) = 4, FIELD) as F2,
...
abhaytrip
Creator
Creator
Author

Thanks alot mate , this really did work. Apprectiate it. (y)