6 Replies Latest reply: Jan 8, 2015 6:35 AM by savitha sri RSS

    How to create a new field using fields from different tables?

      Good afternoon respected members,

       

       

      I am new to qlikview and BI in general. So any help would be appreciated.

       

      I would like to create a new field called 'Costs'. In order to create this field i would need to use two different fields from two different tables. Costs = Product Standard Cost * Order Quantity. The fields involved in this metric are OrderQty and StandardCost. OrderQty can be found under the Sales tab in the second LOAD script and StandardCost can be found under the Product tab in the Product table.

       

      I am attaching a copy of the document. Looking forward for the communities help in this regard.

       

      Thanks,

       

      Ammad