Discussion Board for collaboration related to QlikView App Development.
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
If(DEBTOR_CODE='-' and DEBTORS<>'-', DEBTORS,
If(DEBTOR_CODE='-' and DEBTORS='-','DIR',DEBTOR_CODE)) as DEBTOR_CODE
If(DEBTOR_CODE='-' and DEBTORS<>'-', DEBTORS,
If(DEBTOR_CODE='-' and DEBTORS='-','DIR',DEBTOR_CODE)) as DEBTOR_CODE
Thanks Aar,
This is fine.