topic Bar chart and trend line with calculation in QlikView

topic Bar chart and trend line with calculation in QlikView https://community.qlik.com/t5/QlikView/Bar-chart-and-trend-line-with-calculation/m-p/1176557#M521749 <HTML><HEAD></HEAD><BODY><P>I have the sales data this way</P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">  </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">  </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 128px;"><TBODY><TR><TD height="17" style="border: 0.5pt solid windowtext; border-image: none;" width="64"><SPAN style="color: #000000;">Jan</SPAN></TD><TD align="right" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext;" width="64"><SPAN style="color: #000000;">13</SPAN></TD></TR><TR><TD height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: windowtext;"><SPAN style="color: #000000;">Feb</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: windowtext;"><SPAN style="color: #000000;">20</SPAN></TD></TR><TR><TD height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: windowtext;"><SPAN style="color: #000000;">Mar</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: windowtext;"><SPAN style="color: #000000;">15</SPAN></TD></TR><TR><TD height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: windowtext;"><SPAN style="color: #000000;">Apr</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: windowtext;"><SPAN style="color: #000000;">9</SPAN></TD></TR><TR><TD height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: windowtext;"><SPAN style="color: #000000;">May</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: windowtext;"><SPAN style="color: #000000;">5</SPAN></TD></TR><TR><TD height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: windowtext;"><SPAN style="color: #000000;">Jun</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: windowtext;"><SPAN style="color: #000000;"> </SPAN></TD></TR><TR><TD height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: windowtext;"><SPAN style="color: #000000;">jul</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: windowtext;"><SPAN style="color: #000000;"> </SPAN></TD></TR><TR><TD height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: windowtext;"><SPAN style="color: #000000;">Aug</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: windowtext;"><SPAN style="color: #000000;"> </SPAN></TD></TR><TR><TD height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: windowtext;"><SPAN style="color: #000000;">Sep</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: windowtext;"><SPAN style="color: #000000;"> </SPAN></TD></TR><TR><TD height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: windowtext;"><SPAN style="color: #000000;">Oct</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: windowtext;"><SPAN style="color: #000000;"> </SPAN></TD></TR><TR><TD height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: windowtext;"><SPAN style="color: #000000;">Nov</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: windowtext;"><SPAN style="color: #000000;"> </SPAN></TD></TR><TR><TD height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: windowtext;"><SPAN style="color: #000000;">Dec</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: windowtext;"><SPAN style="color: #000000;"> </SPAN></TD></TR></TBODY></TABLE><P></P><P>I need to show the same as bar chart with cumulative month values. and then add a trendline to the data till dec</P><P></P><P>final outcome should be something like</P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/126321_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P><P>how can do it in Qlikview</P></BODY></HTML> Tue, 31 May 2016 10:08:43 GMT 2016-05-31T10:08:43Z Bar chart and trend line with calculation https://community.qlik.com/t5/QlikView/Bar-chart-and-trend-line-with-calculation/m-p/1176557#M521749 <HTML><HEAD></HEAD><BODY><P>I have the sales data this way</P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">  </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">  </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 128px;"><TBODY><TR><TD height="17" style="border: 0.5pt solid windowtext; border-image: none;" width="64"><SPAN style="color: #000000;">Jan</SPAN></TD><TD align="right" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext;" width="64"><SPAN style="color: #000000;">13</SPAN></TD></TR><TR><TD height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: windowtext;"><SPAN style="color: #000000;">Feb</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: windowtext;"><SPAN style="color: #000000;">20</SPAN></TD></TR><TR><TD height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: windowtext;"><SPAN style="color: #000000;">Mar</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: windowtext;"><SPAN style="color: #000000;">15</SPAN></TD></TR><TR><TD height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: windowtext;"><SPAN style="color: #000000;">Apr</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: windowtext;"><SPAN style="color: #000000;">9</SPAN></TD></TR><TR><TD height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: windowtext;"><SPAN style="color: #000000;">May</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: windowtext;"><SPAN style="color: #000000;">5</SPAN></TD></TR><TR><TD height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: windowtext;"><SPAN style="color: #000000;">Jun</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: windowtext;"><SPAN style="color: #000000;"> </SPAN></TD></TR><TR><TD height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: windowtext;"><SPAN style="color: #000000;">jul</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: windowtext;"><SPAN style="color: #000000;"> </SPAN></TD></TR><TR><TD height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: windowtext;"><SPAN style="color: #000000;">Aug</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: windowtext;"><SPAN style="color: #000000;"> </SPAN></TD></TR><TR><TD height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: windowtext;"><SPAN style="color: #000000;">Sep</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: windowtext;"><SPAN style="color: #000000;"> </SPAN></TD></TR><TR><TD height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: windowtext;"><SPAN style="color: #000000;">Oct</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: windowtext;"><SPAN style="color: #000000;"> </SPAN></TD></TR><TR><TD height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: windowtext;"><SPAN style="color: #000000;">Nov</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: windowtext;"><SPAN style="color: #000000;"> </SPAN></TD></TR><TR><TD height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: windowtext;"><SPAN style="color: #000000;">Dec</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: windowtext;"><SPAN style="color: #000000;"> </SPAN></TD></TR></TBODY></TABLE><P></P><P>I need to show the same as bar chart with cumulative month values. and then add a trendline to the data till dec</P><P></P><P>final outcome should be something like</P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/126321_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P><P>how can do it in Qlikview</P></BODY></HTML> Tue, 31 May 2016 10:08:43 GMT https://community.qlik.com/t5/QlikView/Bar-chart-and-trend-line-with-calculation/m-p/1176557#M521749 2016-05-31T10:08:43Z