Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Highlighted
Not applicable

Aggregation Distinct

Hello,

I have this sample data.

COST_STRUCTUREAmountW4CC
Gas792,721W4CC14AF00
Gas792,721W4CC15BN00
Gas792,721W4CC15BU00
Depresiasi786,488W4CC14AF00
Depresiasi786,488W4CC15BN00
Depresiasi786,488W4CC15BU00
Gas540,492W4CC17CQ00
Gas540,492W4CC17CQ00
Gas540,492W4CC17CQ00
Depresiasi536,242W4CC17CQ00
Depresiasi536,242W4CC17CQ00
Depresiasi536,242W4CC17CQ00

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 StructureTotal Amount
Gas2,918,655
Depresiasi2,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.

1 Reply
ecolomer
Honored Contributor II

Re: Aggregation Distinct

Is this?

Only you need, in the select put DISTINCT

p05.png

LOAD distinct

          COST_STRUCTURE,      Amount,      W4CC

FROM

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

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