Discussion Board for collaboration on QlikView Scripting.
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.
Go to Solution.
if(mid(FIELD, 2, 1) = 2, FIELD) as F1,
if(mid(FIELD, 2, 1) = 4, FIELD) as F2,