topic Re: Using a formula/calculation based on day or dates selected in QlikView https://community.qlik.com/t5/QlikView/Using-a-formula-calculation-based-on-day-or-dates-selected/m-p/1188869#M886268 <HTML><HEAD></HEAD><BODY><P>Thank you! This solved it.</P></BODY></HTML> Tue, 20 Sep 2016 18:55:07 GMT 2016-09-20T18:55:07Z Using a formula/calculation based on day or dates selected https://community.qlik.com/t5/QlikView/Using-a-formula-calculation-based-on-day-or-dates-selected/m-p/1188867#M886266 <HTML><HEAD></HEAD><BODY><P>I have a scenario as follows.</P><P></P><P>Based on the date or date range selected if the date or date range is before 08/29/2016, I wanted to it to do one calculation (e.g A + B) and if anything after 08/29/2016 is selected, it does a different one (A + B + C).</P><P></P><P>I am doing something like this at the moment,</P><P>if(ADate &lt; '08/29/2016', A + B, A + B +C).</P><P></P><P>The above works if I made ONE date selection only which is prior to 08/29/2016 but if I select a date range for e.g Aug 10-13, it does not work.</P><P></P><P>Any help/advice would be much appreciated.</P><P></P><P>Thank you,<BR />Amit</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Using-a-formula-calculation-based-on-day-or-dates-selected/m-p/1188867#M886266 2020-11-25T16:16:04Z Re: Using a formula/calculation based on day or dates selected https://community.qlik.com/t5/QlikView/Using-a-formula-calculation-based-on-day-or-dates-selected/m-p/1188868#M886267 <HTML><HEAD></HEAD><BODY><P>May be try</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">if(<STRONG><EM>Max(ADate)</EM></STRONG>&lt; '08/29/2016', A + B, A + B +C)</SPAN></P></BODY></HTML> Tue, 20 Sep 2016 18:29:24 GMT https://community.qlik.com/t5/QlikView/Using-a-formula-calculation-based-on-day-or-dates-selected/m-p/1188868#M886267 settu_periasamy 2016-09-20T18:29:24Z Re: Using a formula/calculation based on day or dates selected https://community.qlik.com/t5/QlikView/Using-a-formula-calculation-based-on-day-or-dates-selected/m-p/1188869#M886268 <HTML><HEAD></HEAD><BODY><P>Thank you! This solved it.</P></BODY></HTML> Tue, 20 Sep 2016 18:55:07 GMT https://community.qlik.com/t5/QlikView/Using-a-formula-calculation-based-on-day-or-dates-selected/m-p/1188869#M886268 2016-09-20T18:55:07Z