topic How to create an Linechart with index? in QlikView https://community.qlik.com/t5/QlikView/How-to-create-an-Linechart-with-index/m-p/316219#M116662 <HTML><HEAD></HEAD><BODY><P>Hi Michael, </P><P></P><P>You should try this expression : </P><P>sum(pflegetage) / sum({$&lt;Year={'$(=min(Year))'}&gt;}Total pflegetage) </P><P></P><P>I think it will work !</P><P>Good Luck !</P></BODY></HTML> Wed, 21 Dec 2011 08:42:24 GMT 2011-12-21T08:42:24Z How to create an Linechart with index? https://community.qlik.com/t5/QlikView/How-to-create-an-Linechart-with-index/m-p/316218#M116661 <HTML><HEAD></HEAD><BODY><P>Hello </P><P>I want to create a Line Chart as an Index. That means it should start in the year 2007 which is 100% and each following year refers to the first (actually selectet year) and shows the value in % of the basic year. </P><P></P><P>Here is an example how it should look like. Does somone know how to create such a graph that is also dynamic?</P><P></P><P>Thanks for your help</P><P></P><P>Michael</P><P></P><P><IMG alt="Example.gif" class="jive-image-thumbnail jive-image" onclick="" src="https://community.qlik.com/legacyfs/online/9786_Example.gif" width="450" /></P></BODY></HTML> Wed, 21 Dec 2011 08:14:16 GMT https://community.qlik.com/t5/QlikView/How-to-create-an-Linechart-with-index/m-p/316218#M116661 michael84 2011-12-21T08:14:16Z How to create an Linechart with index? https://community.qlik.com/t5/QlikView/How-to-create-an-Linechart-with-index/m-p/316219#M116662 <HTML><HEAD></HEAD><BODY><P>Hi Michael, </P><P></P><P>You should try this expression : </P><P>sum(pflegetage) / sum({$&lt;Year={'$(=min(Year))'}&gt;}Total pflegetage) </P><P></P><P>I think it will work !</P><P>Good Luck !</P></BODY></HTML> Wed, 21 Dec 2011 08:42:24 GMT https://community.qlik.com/t5/QlikView/How-to-create-an-Linechart-with-index/m-p/316219#M116662 2011-12-21T08:42:24Z How to create an Linechart with index? https://community.qlik.com/t5/QlikView/How-to-create-an-Linechart-with-index/m-p/316220#M116663 <HTML><HEAD></HEAD><BODY><P> Hi Paul,</P><P>Thanks a lot for your help it wort out perfect!!</P><P><IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 21 Dec 2011 08:56:52 GMT https://community.qlik.com/t5/QlikView/How-to-create-an-Linechart-with-index/m-p/316220#M116663 michael84 2011-12-21T08:56:52Z