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: 
nevilledhamsiri
Specialist
Specialist

How to Flag combining few conditions

Dear Friends!

I have following dimensions

Debtor_Code,

Debtor & so on. Debtor code carries code numbers & some rows are having just - symbols. Field Debtor too carries codes & as same as Debtor_code, it carries - symbols at some cases. I need following requirement to be made.

If Debtor code carries - symbol, & corresponding Debtor has a code number then that code number to be appeared in the Debtor_code. Also in cases where Debtor code & Debtor both carries  - mark, then the debtor_code to be named as 'DIR' & in all other instances, the Debtor_code which is already there to be appeared as it is in the Debtor_code.I need this to be done at script level

Neville

1 Solution

Accepted Solutions
aarkay29
Specialist
Specialist

If(DEBTOR_CODE='-' and DEBTORS<>'-', DEBTORS,

      If(DEBTOR_CODE='-' and DEBTORS='-','DIR',DEBTOR_CODE)) as DEBTOR_CODE

View solution in original post

2 Replies
aarkay29
Specialist
Specialist

If(DEBTOR_CODE='-' and DEBTORS<>'-', DEBTORS,

      If(DEBTOR_CODE='-' and DEBTORS='-','DIR',DEBTOR_CODE)) as DEBTOR_CODE

nevilledhamsiri
Specialist
Specialist
Author

Thanks Aar,

This is fine.