Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
upaliwije
Creator II
Creator II

Subfield

Hi Friends

In may data table the following field exits

BANK_BRANCH

7287-001

7287-030

7287-050

7268-001

7750-005

if(SUBFIELD(BANK_BRANCH,1,4)='7287','SEYLAN','OTHERS')AS  BANK,

I have written above syntax and but in the results Retrun 'OTHERS' for  record. Pls tell where I am wrong

10 Replies
yuvraj
Partner - Contributor
Partner - Contributor

It should be

if(SUBFIELD(BANK_BRANCH,'-',1)='7287','SEYLAN','OTHERS')AS  BANK

 

 

Regards,