topic Re: what if analysis in QlikView https://community.qlik.com/t5/QlikView/what-if-analysis/m-p/810815#M663569 <HTML><HEAD></HEAD><BODY><P>maybe the attachment can help you</P></BODY></HTML> Mon, 16 Feb 2015 08:40:32 GMT maxgro 2015-02-16T08:40:32Z what if analysis https://community.qlik.com/t5/QlikView/what-if-analysis/m-p/810814#M663567 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I would like to know how what if analysis for the amount column&nbsp; with a specific month</P><P>for e,g , if you the increase amount in Jul by another 100 , how the cumulative value should increase from Jul and at end of Sep total value should be 1070</P><P></P><P>Jul amount - 350, cumulative-750&nbsp; ,890,1070</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 240px;"><TBODY><TR style="height: 15.0pt;"><TD height="20" style="height: 15.0pt; width: 60pt;" width="80">Month</TD><TD style="width: 60pt;" width="80">Amount</TD><TD style="width: 60pt;" width="80">Cumulative</TD></TR><TR style="height: 15.0pt;"><TD height="20" style="height: 15.0pt;">Apr</TD><TD align="right">100</TD><TD align="right">100</TD></TR><TR style="height: 15.0pt;"><TD height="20" style="height: 15.0pt;">May</TD><TD align="right">100</TD><TD align="right">200</TD></TR><TR style="height: 15.0pt;"><TD height="20" style="height: 15.0pt;">Jun</TD><TD align="right">200</TD><TD align="right">400</TD></TR><TR style="height: 15.0pt;"><TD height="20" style="height: 15.0pt;">Jul</TD><TD align="right">250</TD><TD align="right">650</TD></TR><TR style="height: 15.0pt;"><TD height="20" style="height: 15.0pt;">Aug</TD><TD align="right">140</TD><TD align="right">790</TD></TR><TR style="height: 15.0pt;"><TD height="20" style="height: 15.0pt;">Sep</TD><TD align="right">180</TD><TD align="right">970</TD></TR></TBODY></TABLE><P></P><P><STRONG>Jayanthan</STRONG></P></BODY></HTML> Mon, 16 Feb 2015 08:24:44 GMT https://community.qlik.com/t5/QlikView/what-if-analysis/m-p/810814#M663567 2015-02-16T08:24:44Z Re: what if analysis https://community.qlik.com/t5/QlikView/what-if-analysis/m-p/810815#M663569 <HTML><HEAD></HEAD><BODY><P>maybe the attachment can help you</P></BODY></HTML> Mon, 16 Feb 2015 08:40:32 GMT https://community.qlik.com/t5/QlikView/what-if-analysis/m-p/810815#M663569 maxgro 2015-02-16T08:40:32Z