This content has been marked as final.
Show 1 reply
-
Re: calculation (set analysis) during LOAD
Stefan Wühl Nov 29, 2011 11:47 AM (in response to Andreas Dippel)Not really sure what you are after, I am assuming that you want to group your results by ID, Name and location, then a simple approach could look like:
INPUT:
LOAD ID,
name,
location,
unit,
value
FROM
[http://community.qlik.com/thread/39879?tstart=0]
(html, codepage is 1252, embedded labels, table is @1);
MW:
left join LOAD ID, name, location, sum(value) as SumMW Resident INPUT where unit = 'mw' group by ID, name, location ;
Volt:
left join LOAD ID, name, location, sum(value) as SumVolt Resident INPUT where unit = 'volt' group by ID, name, location ;
Result:
LOAD ID, name, location, unit, value, SumMW * SumVolt as Energy resident INPUT;
drop table INPUT;
Is this what you were looking for?
edited left joins