Discussion Board for collaboration related to QlikView Deployment.
I have an excel with old data sheet (OLD):
And new excel with new data sheet (NEW)
1st I would like to get result:
All new data and something from old table that matches with order-revenue:
Last row is from old table, because 2-5 matches with new table.
Next, what i want is to do is do calculation, summarize 2-5 rows and the update old table with new:
Old sheet + new calculated sheet
Can you help me please?
Go to Solution.
I figured out myself:
(ooxml, embedded labels, table is New);
//where not exists([OrderId-Revenue]);
(ooxml, embedded labels, table is Old)
sum(Revenue) as Revenue,
sum(Other) as Other
group by [OrderId-Revenue],OrderId ;
drop tables table1;
where not exists([OrderId-Revenue]);