Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
nevilledhamsiri
Valued Contributor

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
Highlighted
aarkay29
Valued Contributor

Re: How to Flag combining few conditions

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

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

View solution in original post

2 Replies
Highlighted
aarkay29
Valued Contributor

Re: How to Flag combining few conditions

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

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

View solution in original post

Highlighted
nevilledhamsiri
Valued Contributor

Re: How to Flag combining few conditions

Thanks Aar,

This is fine.