Discussion Board for collaboration related to Qlik Education.
I have this sample data.
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 :
Gas is From Amount W4CC15BU00 + W4CC14AF00 + W4CC15BN00 + W4CC17CQ00, but all of them is distinct by W4CC.
Paulus Indra Salim.
Only you need, in the select put DISTINCT
COST_STRUCTURE, Amount, W4CC
(html, codepage is 1252, embedded labels, table is @1);