Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
You can just do as below -
Price-Value as Gain
From ...
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.
You can just do as below -
Price-Value as Gain
From ...
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!