topic Re: Accumulated values in Water Cooler https://community.qlik.com/t5/Water-Cooler/Accumulated-values/m-p/738884#M3432 <HTML><HEAD></HEAD><BODY><P>hi Sunil,</P><P></P><P>Try this:</P><P></P><P>above(TOTAL Sum(Col1))-Sum(Col1)</P><P></P><P>Best Regards,</P><P></P><P>Ale</P></BODY></HTML> Thu, 24 Jul 2014 12:27:15 GMT male_carrasco 2014-07-24T12:27:15Z Accumulated values https://community.qlik.com/t5/Water-Cooler/Accumulated-values/m-p/738883#M3431 <HTML><HEAD></HEAD><BODY><P>I have a scenario where&nbsp; need to same in straight table using only Date and Col1 fields in qlikview&nbsp; please find the attached and do same calculation used in Value cells&nbsp; press F2 in excel </P></BODY></HTML> Thu, 24 Jul 2014 12:04:21 GMT https://community.qlik.com/t5/Water-Cooler/Accumulated-values/m-p/738883#M3431 sunilkumarqv 2014-07-24T12:04:21Z Re: Accumulated values https://community.qlik.com/t5/Water-Cooler/Accumulated-values/m-p/738884#M3432 <HTML><HEAD></HEAD><BODY><P>hi Sunil,</P><P></P><P>Try this:</P><P></P><P>above(TOTAL Sum(Col1))-Sum(Col1)</P><P></P><P>Best Regards,</P><P></P><P>Ale</P></BODY></HTML> Thu, 24 Jul 2014 12:27:15 GMT https://community.qlik.com/t5/Water-Cooler/Accumulated-values/m-p/738884#M3432 male_carrasco 2014-07-24T12:27:15Z