Aggregation Distinct

[#1]

Hello,

I have this sample data.

COST_STRUCTURE	Amount	W4CC
Gas	792,721	W4CC14AF00
Gas	792,721	W4CC15BN00
Gas	792,721	W4CC15BU00
Depresiasi	786,488	W4CC14AF00
Depresiasi	786,488	W4CC15BN00
Depresiasi	786,488	W4CC15BU00
Gas	540,492	W4CC17CQ00
Gas	540,492	W4CC17CQ00
Gas	540,492	W4CC17CQ00
Depresiasi	536,242	W4CC17CQ00
Depresiasi	536,242	W4CC17CQ00
Depresiasi	536,242	W4CC17CQ00

So I want to create a chart to know how much di Sum(Distinct Amount) per W4CC, but the Dimension is COST_STRUCTURE.

More or less, the chart will be like this :

Cost Structure	Total Amount
Gas	2,918,655
Depresiasi	2,895,706

Gas is From Amount W4CC15BU00 + W4CC14AF00 + W4CC15BN00 + W4CC17CQ00, but all of them is distinct by W4CC.

Please help!

Thanks

Regards,

Paulus Indra Salim.

[ecolomer]

Is this?

Only you need, in the select put DISTINCT

LOAD distinct

          COST_STRUCTURE,      Amount,      W4CC

FROM

[http://community.qlik.com/thread/136835]

(html, codepage is 1252, embedded labels, table is @1);