topic Calculate values from start to today's date in QlikView https://community.qlik.com/t5/QlikView/Calculate-values-from-start-to-today-s-date/m-p/733142#M262672 <HTML><HEAD></HEAD><BODY><P>Hi Peeps,</P><P></P><P>I need your help to solve this problem. Basically, i need&nbsp; to merge portfolio and stock tables and calculate the <STRONG>current portfolio value</STRONG> for <STRONG>each date</STRONG>, starting from buying date till today's date and invested amount on a separate table (on load script).</P><P>The problem here is</P><P>1. how to merge and create the invested and current value table</P><P>2. how to sum based on "Buy" and "Sell", and aggregate based on the shares type(APPL and BMZ as shown below).</P><P></P><P>Your help is much appreciated!!!</P><P><IMG __jive_id="68990" alt="QlikviewForum.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/68990_QlikviewForum.png" style="width: 620px; height: 346px;" /></P></BODY></HTML> Wed, 15 Oct 2014 14:59:34 GMT 2014-10-15T14:59:34Z Calculate values from start to today's date https://community.qlik.com/t5/QlikView/Calculate-values-from-start-to-today-s-date/m-p/733142#M262672 <HTML><HEAD></HEAD><BODY><P>Hi Peeps,</P><P></P><P>I need your help to solve this problem. Basically, i need&nbsp; to merge portfolio and stock tables and calculate the <STRONG>current portfolio value</STRONG> for <STRONG>each date</STRONG>, starting from buying date till today's date and invested amount on a separate table (on load script).</P><P>The problem here is</P><P>1. how to merge and create the invested and current value table</P><P>2. how to sum based on "Buy" and "Sell", and aggregate based on the shares type(APPL and BMZ as shown below).</P><P></P><P>Your help is much appreciated!!!</P><P><IMG __jive_id="68990" alt="QlikviewForum.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/68990_QlikviewForum.png" style="width: 620px; height: 346px;" /></P></BODY></HTML> Wed, 15 Oct 2014 14:59:34 GMT https://community.qlik.com/t5/QlikView/Calculate-values-from-start-to-today-s-date/m-p/733142#M262672 2014-10-15T14:59:34Z