topic Equation help in QlikView https://community.qlik.com/t5/QlikView/Equation-help/m-p/1338841#M821795 <HTML><HEAD></HEAD><BODY><P>I am trying to backlog some data and only have the value total. I am trying to write an equation that will allow me to add a total revenue to the revenue I have accumulated by area. The equation I have for that is this:</P><P></P><P>Sum({$&lt;Status_Dash={'Completed'}, Year = {"$(=Year(FirstWorkDate(ConvertToLocalTime(Date(now()), 'GMT-05:00'),1,$(vHolidays))))"}&gt;} (Ave_Cost_Dash * Processed_Dash))</P><P></P><P>I simply want to add revenue from Jan, Feb, Mar, Apr, May from this year to this equation.</P><P>So how can I add</P><P></P><P>if current year is equal to 2017</P><P>then add total_revenue from jan, feb, mar, apr, may in 2017.</P><P></P><P>I am trying to add this so I won't have to go back at the beginning of next year and take out those from all my expressions. </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT joshrussin 2020-11-25T16:16:04Z Equation help https://community.qlik.com/t5/QlikView/Equation-help/m-p/1338841#M821795 <HTML><HEAD></HEAD><BODY><P>I am trying to backlog some data and only have the value total. I am trying to write an equation that will allow me to add a total revenue to the revenue I have accumulated by area. The equation I have for that is this:</P><P></P><P>Sum({$&lt;Status_Dash={'Completed'}, Year = {"$(=Year(FirstWorkDate(ConvertToLocalTime(Date(now()), 'GMT-05:00'),1,$(vHolidays))))"}&gt;} (Ave_Cost_Dash * Processed_Dash))</P><P></P><P>I simply want to add revenue from Jan, Feb, Mar, Apr, May from this year to this equation.</P><P>So how can I add</P><P></P><P>if current year is equal to 2017</P><P>then add total_revenue from jan, feb, mar, apr, may in 2017.</P><P></P><P>I am trying to add this so I won't have to go back at the beginning of next year and take out those from all my expressions. </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Equation-help/m-p/1338841#M821795 joshrussin 2020-11-25T16:16:04Z Re: Equation help https://community.qlik.com/t5/QlikView/Equation-help/m-p/1338842#M821796 <HTML><HEAD></HEAD><BODY><P>Seems like you are trying to accumulated Sum? May be try using <A href="https://community.qlik.com/qlik-blogpost/4531">The As-Of Table</A></P></BODY></HTML> Wed, 02 Aug 2017 16:51:01 GMT https://community.qlik.com/t5/QlikView/Equation-help/m-p/1338842#M821796 sunny_talwar 2017-08-02T16:51:01Z