topic Re: How to Flag combining few conditions in QlikView https://community.qlik.com/t5/QlikView/How-to-Flag-combining-few-conditions/m-p/132286#M755717 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 13.3333px;"><STRONG> If(DEBTOR_CODE='-' and DEBTORS&lt;&gt;'-', DEBTORS,</STRONG></SPAN></P><P><SPAN style="font-size: 13.3333px;"><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If(DEBTOR_CODE='-' and DEBTORS='-','DIR',DEBTOR_CODE)) as DEBTOR_CODE</STRONG></SPAN></P></BODY></HTML> Wed, 03 Oct 2018 17:08:45 GMT aarkay29 2018-10-03T17:08:45Z How to Flag combining few conditions https://community.qlik.com/t5/QlikView/How-to-Flag-combining-few-conditions/m-p/132285#M755716 <HTML><HEAD></HEAD><BODY><P>Dear Friends!</P><P></P><P>I have following dimensions</P><P>Debtor_Code,</P><P>Debtor &amp; so on. Debtor code carries code numbers &amp; some rows are having just - symbols. Field Debtor too carries codes &amp; as same as Debtor_code, it carries - symbols at some cases. I need following requirement to be made.</P><P>If Debtor code carries - symbol, &amp; corresponding Debtor has a code number then that code number to be appeared in the Debtor_code. Also in cases where Debtor code &amp; Debtor both carries&nbsp; - mark, then the debtor_code to be named as 'DIR' &amp; 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</P><P></P><P>Neville</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-Flag-combining-few-conditions/m-p/132285#M755716 nevilledhamsiri 2020-11-25T16:16:04Z Re: How to Flag combining few conditions https://community.qlik.com/t5/QlikView/How-to-Flag-combining-few-conditions/m-p/132286#M755717 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 13.3333px;"><STRONG> If(DEBTOR_CODE='-' and DEBTORS&lt;&gt;'-', DEBTORS,</STRONG></SPAN></P><P><SPAN style="font-size: 13.3333px;"><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If(DEBTOR_CODE='-' and DEBTORS='-','DIR',DEBTOR_CODE)) as DEBTOR_CODE</STRONG></SPAN></P></BODY></HTML> Wed, 03 Oct 2018 17:08:45 GMT https://community.qlik.com/t5/QlikView/How-to-Flag-combining-few-conditions/m-p/132286#M755717 aarkay29 2018-10-03T17:08:45Z Re: How to Flag combining few conditions https://community.qlik.com/t5/QlikView/How-to-Flag-combining-few-conditions/m-p/132287#M755718 <HTML><HEAD></HEAD><BODY><P>Thanks Aar,</P><P></P><P>This is fine.</P></BODY></HTML> Wed, 03 Oct 2018 17:41:24 GMT https://community.qlik.com/t5/QlikView/How-to-Flag-combining-few-conditions/m-p/132287#M755718 nevilledhamsiri 2018-10-03T17:41:24Z