topic Re: How to load field value as sum() of different field's table in QlikView

How to load field value as sum() of different field's table

vittorianad — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

let's say I have

Order:
load
id_order,
date_order,
id_client
from [qvd\order.qvd] (qvd);

lineOrder:
load
id_order,
id_line_order,
ammount_line
from [qvd\orderline.qvd] (qvd);

I need the total ammount calculated on the Order table.

How can I get this?

I want the Order table to be

Order:
load
id_order,
Date_order,
id_client,
total_ammount_order
from [qvd\order.qvd] (qvd);

Thanks to all

martinpohl — Wed, 22 May 2019 07:59:16 GMT

Hi,

Orders:
load
id_order,
date_order,
id_client
from [qvd\order.qvd] (qvd);

left join (Orders)
load
id_order,
id_line_order,
ammount_line
from [qvd\order.qvd] (qvd);

left join (Orders)

load

id_order,

sum(ammount_line) as sumorder

resident Orders

group by id_order;

Regards

vittorianad — Wed, 22 May 2019 08:31:18 GMT

hi,

I want to keep separated the Order and the Orderline table,

the code you suggest does the left join...