https://community.qlik.com/t5/QlikView/To-increase-the-bill-amount-by/m-p/1623935#M734235 <P>To increase the bill amount by % if last pay date &lt; current date</P><P>&nbsp;for next 7 days &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12.5%</P><P>&nbsp;for next 10 days &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15%</P> Wed, 25 Nov 2020 16:16:04 GMT mithunr40 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/To-increase-the-bill-amount-by/m-p/1623935#M734235 <P>To increase the bill amount by % if last pay date &lt; current date</P><P>&nbsp;for next 7 days &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12.5%</P><P>&nbsp;for next 10 days &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15%</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/To-increase-the-bill-amount-by/m-p/1623935#M734235 mithunr40 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/To-increase-the-bill-amount-by/m-p/1623944#M734236 <P>I would probably do this in the script, but it is possible to use it front end inside an expression as well</P><P>&nbsp;</P><P><STRONG>If(today()-LastPayDate &gt;=10,</STRONG> //identify 10d or more</P><P>&nbsp; &nbsp;<STRONG>BillAmount * 1.15,</STRONG></P><P><STRONG>&nbsp; &nbsp;If(today()-LastPayDate &gt;=7,</STRONG> //identify 7-10 days</P><P>&nbsp; &nbsp; &nbsp; <STRONG>BillAmount * 1.125,</STRONG></P><P>&nbsp; &nbsp; &nbsp; <STRONG>BillAmount * 1.00 )</STRONG> AS NewBillAmount</P><P>&nbsp;</P><P>&nbsp;</P> Sun, 15 Sep 2019 05:56:47 GMT https://community.qlik.com/t5/QlikView/To-increase-the-bill-amount-by/m-p/1623944#M734236 Vegar 2019-09-15T05:56:47Z