topic Re: Creating future bars in QlikView https://community.qlik.com/t5/QlikView/Creating-future-bars/m-p/297885#M110485 <HTML><HEAD></HEAD><BODY><P>Well, the attached is using a linear trend instead of the calculation you mentioned, but it shows several different ways of showing forecast data, including bars.</P></BODY></HTML> Fri, 13 May 2011 19:54:17 GMT johnw 2011-05-13T19:54:17Z Creating future bars https://community.qlik.com/t5/QlikView/Creating-future-bars/m-p/297884#M110484 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I have a bar shart where I have something like the image.<BR />Now I want to give some future bars.</P><P></P><P>as example I want to sum&nbsp; the last tree bars and divide this by the number of products in the three months and mulitiply it by the number of product from the next month to create the bar of the next month.</P><P></P><P>Who can help me?</P><P></P><P>Kind regards,</P><P></P><P>martijn</P><P></P><P></P></BODY></HTML> Fri, 13 May 2011 14:13:01 GMT https://community.qlik.com/t5/QlikView/Creating-future-bars/m-p/297884#M110484 2011-05-13T14:13:01Z Re: Creating future bars https://community.qlik.com/t5/QlikView/Creating-future-bars/m-p/297885#M110485 <HTML><HEAD></HEAD><BODY><P>Well, the attached is using a linear trend instead of the calculation you mentioned, but it shows several different ways of showing forecast data, including bars.</P></BODY></HTML> Fri, 13 May 2011 19:54:17 GMT https://community.qlik.com/t5/QlikView/Creating-future-bars/m-p/297885#M110485 johnw 2011-05-13T19:54:17Z