topic Expression to mark recovered amount in QlikView https://community.qlik.com/t5/QlikView/Expression-to-mark-recovered-amount/m-p/1420619#M814367 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P></P><P style="text-align: justify;">Please help me on my requirement to show in the attached table. I need to show the amount recovered in a column which is more than the budget. As can be seen the column " <SPAN style="text-decoration: underline;">Excess to be recovered</SPAN>"&nbsp; carries such balances of which only negative balance to be recovered. I need to show in this column&nbsp; </P><P style="text-align: justify;">** All negative balances against&nbsp; each Month to be shown as a positive figure!</P><P style="text-align: justify;">** Values which carry 0 balances to be shown&nbsp; as 0 balances as something not recoverable!</P><P style="text-align: justify;">** Latest Month balance&nbsp; needs to be treated as not recovered by showing the same amount as a positive figure!</P><P style="text-align: justify;">** Total row should always carry the total excluding latest Month figure!</P><P style="text-align: justify;"></P><P style="text-align: justify;">** As I continue this recovery process in to the future Months &amp; so on&nbsp; always the&nbsp; latest Month balance should always to be stated as a positive figure to be recovered.</P><P style="text-align: justify;"></P><P style="text-align: justify;">By incorporating all these factors, please propose an expression</P><P style="text-align: justify;"></P><P style="text-align: justify;">Regards</P><P style="text-align: justify;"></P><P style="text-align: justify;">Neville</P><P style="text-align: justify;"></P><P></P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/176623_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT nevilledhamsiri 2020-11-25T16:16:04Z Expression to mark recovered amount https://community.qlik.com/t5/QlikView/Expression-to-mark-recovered-amount/m-p/1420619#M814367 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P></P><P style="text-align: justify;">Please help me on my requirement to show in the attached table. I need to show the amount recovered in a column which is more than the budget. As can be seen the column " <SPAN style="text-decoration: underline;">Excess to be recovered</SPAN>"&nbsp; carries such balances of which only negative balance to be recovered. I need to show in this column&nbsp; </P><P style="text-align: justify;">** All negative balances against&nbsp; each Month to be shown as a positive figure!</P><P style="text-align: justify;">** Values which carry 0 balances to be shown&nbsp; as 0 balances as something not recoverable!</P><P style="text-align: justify;">** Latest Month balance&nbsp; needs to be treated as not recovered by showing the same amount as a positive figure!</P><P style="text-align: justify;">** Total row should always carry the total excluding latest Month figure!</P><P style="text-align: justify;"></P><P style="text-align: justify;">** As I continue this recovery process in to the future Months &amp; so on&nbsp; always the&nbsp; latest Month balance should always to be stated as a positive figure to be recovered.</P><P style="text-align: justify;"></P><P style="text-align: justify;">By incorporating all these factors, please propose an expression</P><P style="text-align: justify;"></P><P style="text-align: justify;">Regards</P><P style="text-align: justify;"></P><P style="text-align: justify;">Neville</P><P style="text-align: justify;"></P><P></P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/176623_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Expression-to-mark-recovered-amount/m-p/1420619#M814367 nevilledhamsiri 2020-11-25T16:16:04Z Re: Expression to mark recovered amount https://community.qlik.com/t5/QlikView/Expression-to-mark-recovered-amount/m-p/1420620#M814368 <HTML><HEAD></HEAD><BODY><P>Dear Sunny,</P><P></P><P>Will you be able to help me on this? Also if I am to apply conditional&nbsp; formatting like coloring negative balances etc, how it could be achieved?</P><P></P><P>Regards</P><P></P><P>Neville</P></BODY></HTML> Thu, 14 Sep 2017 16:23:55 GMT https://community.qlik.com/t5/QlikView/Expression-to-mark-recovered-amount/m-p/1420620#M814368 nevilledhamsiri 2017-09-14T16:23:55Z