topic Combining Static Data With Dynamic in QlikView https://community.qlik.com/t5/QlikView/Combining-Static-Data-With-Dynamic/m-p/513163#M191753 <HTML><HEAD></HEAD><BODY><P>PastData:</P><P></P><P>MonthYear&nbsp;&nbsp;&nbsp;&nbsp; TopClients</P><P>03/2010&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .68</P><P>06/2010&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .68</P><P>09/2010&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .62</P><P>12/2010&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .65</P><P>03/2011&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .64</P><P>06/2011&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .65</P><P>09/2011&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .67</P><P>12/2011&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .65</P><P></P><P>I create a Line Chart and use Count() function to calculate vlaues over time form another QVD file that contains data from Jan 2012 onwards.</P><P></P><P>I need to append above static data to the begining of the line chart (as it is) and show calculated values from 01/2012 onwards.</P></BODY></HTML> Wed, 26 Jun 2013 19:45:14 GMT Anonymous 2013-06-26T19:45:14Z Combining Static Data With Dynamic https://community.qlik.com/t5/QlikView/Combining-Static-Data-With-Dynamic/m-p/513163#M191753 <HTML><HEAD></HEAD><BODY><P>PastData:</P><P></P><P>MonthYear&nbsp;&nbsp;&nbsp;&nbsp; TopClients</P><P>03/2010&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .68</P><P>06/2010&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .68</P><P>09/2010&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .62</P><P>12/2010&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .65</P><P>03/2011&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .64</P><P>06/2011&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .65</P><P>09/2011&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .67</P><P>12/2011&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .65</P><P></P><P>I create a Line Chart and use Count() function to calculate vlaues over time form another QVD file that contains data from Jan 2012 onwards.</P><P></P><P>I need to append above static data to the begining of the line chart (as it is) and show calculated values from 01/2012 onwards.</P></BODY></HTML> Wed, 26 Jun 2013 19:45:14 GMT https://community.qlik.com/t5/QlikView/Combining-Static-Data-With-Dynamic/m-p/513163#M191753 Anonymous 2013-06-26T19:45:14Z