Create New Field in Data Load Editor by Subtracting two other columns
Hi everyone,
I have an excel sheet with various values. I want to create a new field in the data load editor that is the value of one columns subtracted from another column. For example:
LOAD
Value,
Price,
SUM(Price-Value)
as Gain
From....
This does not work but has the idea behind what I am trying to do, I am pretty new to Qlik so I was hoping someone could help me out? Thanks ahead of time!
Do you need to use 'SUM' in the script, normally we use aggregated functions in the chart measure, if you need aggregation in the script then you would need group by clause as well in the load statement.
Do you need to use 'SUM' in the script, normally we use aggregated functions in the chart measure, if you need aggregation in the script then you would need group by clause as well in the load statement.
Oh is it really that easy? Thank you so much! I feel like I tried that earlier but probably forgot a comma somewhere and just decided it can't be that simple. It seems to work!
