6 Replies Latest reply: Aug 3, 2011 10:53 AM by Aissam Boumejjane RSS

    lost in translation

    Aissam Boumejjane

      Hi There,

       

      I'm following the Qlikview "Get started: Developers Course" I'm a bit lost in translation.

       

      I'm trying to translate the following code/script:

      UnitPrice*Quantity*(1-Discount) AS Sales

       

      OrderDetails:

      LOAD Discount,

          LineNo,

          OrderID,

          ProductID,

          Quantity,

          UnitPrice;

      SQL SELECT *

      FROM `Order Details`;

       

      There is no explanation given in the course what this means and why, therefore i'm trying to use my own interpatation of the script. What it says is: Load field "UnitPrice" multiply by Quantity minus 1 discount and named it as Sales. It's properbly wrong But can someone help me translate it to normal English.

       

      Thanks in advance!!

       

      Isam, a qlikview newbie