Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
LOAD if(mid(FIELD, 2, 1) = 2, FIELD) as F1, if(mid(FIELD, 2, 1) = 4, FIELD) as F2, ...
LOAD if(mid(FIELD, 2, 1) = 2, FIELD) as F1, if(mid(FIELD, 2, 1) = 4, FIELD) as F2, ...