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

    Adding calculated columns with data load editor



      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:





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

      (ooxml, embedded labels, table is Sheet1);


      I append to the Main section:


          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?