topic Find ALL previous days sales in QlikView https://community.qlik.com/t5/QlikView/Find-ALL-previous-days-sales/m-p/116304#M754061 <HTML><HEAD></HEAD><BODY><P>Hello Team,</P><P></P><P>I have a data like below:</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Days</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>SALES</STRONG></TH></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">10</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">5</TD></TR><TR><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">15</TD></TR><TR><TD style="padding: 2px;">4</TD><TD style="padding: 2px;">20</TD></TR></TBODY></TABLE><P>RESULTS:</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>DAYS</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>SALES</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>ALL DAYS</STRONG></TH></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">10</TD><TD style="padding: 2px;">10</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">5</TD><TD style="padding: 2px;">15(Previous days sales10+5)</TD></TR><TR><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">15</TD><TD style="padding: 2px;">30(Previous days sales 10+5+15) same for others aswell</TD></TR><TR><TD style="padding: 2px;">4</TD><TD style="padding: 2px;">20</TD><TD style="padding: 2px;">50</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT gireesh1216 2020-11-25T16:16:04Z Find ALL previous days sales https://community.qlik.com/t5/QlikView/Find-ALL-previous-days-sales/m-p/116304#M754061 <HTML><HEAD></HEAD><BODY><P>Hello Team,</P><P></P><P>I have a data like below:</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Days</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>SALES</STRONG></TH></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">10</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">5</TD></TR><TR><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">15</TD></TR><TR><TD style="padding: 2px;">4</TD><TD style="padding: 2px;">20</TD></TR></TBODY></TABLE><P>RESULTS:</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>DAYS</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>SALES</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>ALL DAYS</STRONG></TH></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">10</TD><TD style="padding: 2px;">10</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">5</TD><TD style="padding: 2px;">15(Previous days sales10+5)</TD></TR><TR><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">15</TD><TD style="padding: 2px;">30(Previous days sales 10+5+15) same for others aswell</TD></TR><TR><TD style="padding: 2px;">4</TD><TD style="padding: 2px;">20</TD><TD style="padding: 2px;">50</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Find-ALL-previous-days-sales/m-p/116304#M754061 gireesh1216 2020-11-25T16:16:04Z Re: Find ALL previous days sales https://community.qlik.com/t5/QlikView/Find-ALL-previous-days-sales/m-p/116305#M754062 <HTML><HEAD></HEAD><BODY><P>Dimension = ID</P><P>Expression1 = sum(SALES)</P><P>Expression2 = Rangesum(above(sum(SALES),0,RowNo()))</P></BODY></HTML> Thu, 27 Sep 2018 18:02:43 GMT https://community.qlik.com/t5/QlikView/Find-ALL-previous-days-sales/m-p/116305#M754062 Frank_Hartmann 2018-09-27T18:02:43Z Re: Find ALL previous days sales https://community.qlik.com/t5/QlikView/Find-ALL-previous-days-sales/m-p/116306#M754063 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>you could also use the standard "full accumulation" option in your chart properties:</P><P><IMG alt="QlikCommunity_Thread_315282_Pic1.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/214629_QlikCommunity_Thread_315282_Pic1.JPG" style="height: auto; width: auto;" /></P><P></P><P><IMG alt="QlikCommunity_Thread_315282_Pic2.JPG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/214630_QlikCommunity_Thread_315282_Pic2.JPG" style="height: 404px; width: 620px;" /></P><P></P><P></P><P>hope this helps</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Thu, 27 Sep 2018 18:28:14 GMT https://community.qlik.com/t5/QlikView/Find-ALL-previous-days-sales/m-p/116306#M754063 MarcoWedel 2018-09-27T18:28:14Z