Discussion Board for collaboration on QlikView Scripting.
I am facing a (i'm sure it is) really easy problem...
I have two tables, let's say :
FROM a.qvd (qvd);
FROM b.qvd (qvd);
In the end, i'd like to have a Table C with the following columns :
metricA + metricB
Thanks a lot for your help.
If I understood correctly, you should be able to join the two tables and then do a rangesum of fields metricA and metricB, maybe like this (untested):
left join (TableA) LOAD
LOAD *, rangesum(metricA,metricB) as SumOfMetrics resident TableA;
drop table TableA,
//drop fields metricA,metricB; //drop if needed