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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.