9 Replies Latest reply: Nov 2, 2015 9:32 PM by Lily Matsushima RSS

    Adding calculated columns with data load editor

      Hello,

       

      I use Qlik Sense and try to add a calculated column to my data.

      I use data load editor.

       

      The script in auto-generated section is:

      LOAD

          Product,

          "Date",

          Amount

      FROM [lib://QilkViewData/Book1.xlsx]

      (ooxml, embedded labels, table is Sheet1);

       

      I append to the Main section:

      LOAD

          Month("Date") as vMonth

      FROM [lib://QilkViewData/Book1.xlsx]

      (ooxml, embedded labels, table is Sheet1);

       

      then I reload my data.

       

      It gives me vMonth column but when I plot bar chart sum(Amount) vs vMonth, it gives me constant values of sum(Amount) for all the data (see attached project). How do I correct it?

       

      Also, when I try to add a column with complex formula (e.g. sum({<Product = {"A"}>}Amount as vACost), it gives me errors. How do I add a such a column to my data?