topic Use sheet object or script in QlikView https://community.qlik.com/t5/QlikView/Use-sheet-object-or-script/m-p/765510#M1048044 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Quite new in QV and have a problem.</P><P></P><P>I'm trying to create a portfolio application. </P><P>I would like to calculate a new dimension with data from two actual dimensions in two different tables. </P><P></P><P>In my LoadTable(.csv file from a web-address that holds historic stock information) I have several dimensions where I would like to multiply the latest value of my dimension "Close" (Dimension date in LoadTable = Today). Thereafter I would like to multiply with "CurrentHoldings" in my table Stocks to get the ActualValue. </P><P><BR />This operation should be looped for all my stocks in my table Stocks. </P><P></P><P>How can this script look like? Or can it be done in any sheet object?</P><P></P><P>BR,</P><P>Alex</P></BODY></HTML> Tue, 18 Nov 2014 07:53:02 GMT 2014-11-18T07:53:02Z Use sheet object or script https://community.qlik.com/t5/QlikView/Use-sheet-object-or-script/m-p/765510#M1048044 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Quite new in QV and have a problem.</P><P></P><P>I'm trying to create a portfolio application. </P><P>I would like to calculate a new dimension with data from two actual dimensions in two different tables. </P><P></P><P>In my LoadTable(.csv file from a web-address that holds historic stock information) I have several dimensions where I would like to multiply the latest value of my dimension "Close" (Dimension date in LoadTable = Today). Thereafter I would like to multiply with "CurrentHoldings" in my table Stocks to get the ActualValue. </P><P><BR />This operation should be looped for all my stocks in my table Stocks. </P><P></P><P>How can this script look like? Or can it be done in any sheet object?</P><P></P><P>BR,</P><P>Alex</P></BODY></HTML> Tue, 18 Nov 2014 07:53:02 GMT https://community.qlik.com/t5/QlikView/Use-sheet-object-or-script/m-p/765510#M1048044 2014-11-18T07:53:02Z