topic Aggregation Distinct in Qlik Learning Discussions https://community.qlik.com/t5/Qlik-Learning-Discussions/Aggregation-Distinct/m-p/677083#M439 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have this sample data.</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 238px;"><TBODY><TR><TD class="xl63" height="20" width="110">COST_STRUCTURE</TD><TD class="xl63" style="border-left: none;" width="52">Amount</TD><TD class="xl63" style="border-left: none;" width="76">W4CC</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">Gas</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">792,721</TD><TD class="xl66" style="border-top: none; border-left: none;">W4CC14AF00</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">Gas</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">792,721</TD><TD class="xl66" style="border-top: none; border-left: none;">W4CC15BN00</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">Gas</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">792,721</TD><TD class="xl66" style="border-top: none; border-left: none;">W4CC15BU00</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">Depresiasi</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">786,488</TD><TD class="xl66" style="border-top: none; border-left: none;">W4CC14AF00</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">Depresiasi</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">786,488</TD><TD class="xl66" style="border-top: none; border-left: none;">W4CC15BN00</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">Depresiasi</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">786,488</TD><TD class="xl66" style="border-top: none; border-left: none;">W4CC15BU00</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">Gas</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">540,492</TD><TD class="xl66" style="border-top: none; border-left: none;">W4CC17CQ00</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">Gas</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">540,492</TD><TD class="xl66" style="border-top: none; border-left: none;">W4CC17CQ00</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">Gas</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">540,492</TD><TD class="xl66" style="border-top: none; border-left: none;">W4CC17CQ00</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">Depresiasi</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">536,242</TD><TD class="xl66" style="border-top: none; border-left: none;">W4CC17CQ00</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">Depresiasi</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">536,242</TD><TD class="xl66" style="border-top: none; border-left: none;">W4CC17CQ00</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">Depresiasi</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">536,242</TD><TD class="xl66" style="border-top: none; border-left: none;">W4CC17CQ00</TD></TR></TBODY></TABLE><P></P><P>So I want to create a chart to know how much di Sum(Distinct Amount) per W4CC, but the Dimension is COST_STRUCTURE.</P><P>More or less, the chart will be like this :</P><TABLE border="0" cellpadding="0" cellspacing="0" width="173"><TBODY><TR><TD class="xl65" height="20" width="89">Cost Structure</TD><TD class="xl65" width="84">Total Amount</TD></TR><TR><TD height="20">Gas</TD><TD align="right" class="xl66">2,918,655</TD></TR><TR><TD height="20">Depresiasi</TD><TD align="right" class="xl66">2,895,706</TD></TR></TBODY></TABLE><P></P><P>Gas is From Amount W4CC15BU00 + <SPAN style="font-size: 13.6000003814697px;">W4CC14AF00 + <SPAN style="font-size: 13.6000003814697px;">W4CC15BN00 + <SPAN style="font-size: 13.6000003814697px;">W4CC17CQ00, but all of them is distinct by W4CC.</SPAN></SPAN></SPAN></P><P></P><P>Please help!</P><P></P><P>Thanks</P><P><BR />Regards,</P><P></P><P>Paulus Indra Salim.</P></BODY></HTML> Wed, 08 Oct 2014 03:48:57 GMT 2014-10-08T03:48:57Z Aggregation Distinct https://community.qlik.com/t5/Qlik-Learning-Discussions/Aggregation-Distinct/m-p/677083#M439 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have this sample data.</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 238px;"><TBODY><TR><TD class="xl63" height="20" width="110">COST_STRUCTURE</TD><TD class="xl63" style="border-left: none;" width="52">Amount</TD><TD class="xl63" style="border-left: none;" width="76">W4CC</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">Gas</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">792,721</TD><TD class="xl66" style="border-top: none; border-left: none;">W4CC14AF00</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">Gas</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">792,721</TD><TD class="xl66" style="border-top: none; border-left: none;">W4CC15BN00</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">Gas</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">792,721</TD><TD class="xl66" style="border-top: none; border-left: none;">W4CC15BU00</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">Depresiasi</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">786,488</TD><TD class="xl66" style="border-top: none; border-left: none;">W4CC14AF00</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">Depresiasi</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">786,488</TD><TD class="xl66" style="border-top: none; border-left: none;">W4CC15BN00</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">Depresiasi</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">786,488</TD><TD class="xl66" style="border-top: none; border-left: none;">W4CC15BU00</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">Gas</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">540,492</TD><TD class="xl66" style="border-top: none; border-left: none;">W4CC17CQ00</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">Gas</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">540,492</TD><TD class="xl66" style="border-top: none; border-left: none;">W4CC17CQ00</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">Gas</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">540,492</TD><TD class="xl66" style="border-top: none; border-left: none;">W4CC17CQ00</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">Depresiasi</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">536,242</TD><TD class="xl66" style="border-top: none; border-left: none;">W4CC17CQ00</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">Depresiasi</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">536,242</TD><TD class="xl66" style="border-top: none; border-left: none;">W4CC17CQ00</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">Depresiasi</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">536,242</TD><TD class="xl66" style="border-top: none; border-left: none;">W4CC17CQ00</TD></TR></TBODY></TABLE><P></P><P>So I want to create a chart to know how much di Sum(Distinct Amount) per W4CC, but the Dimension is COST_STRUCTURE.</P><P>More or less, the chart will be like this :</P><TABLE border="0" cellpadding="0" cellspacing="0" width="173"><TBODY><TR><TD class="xl65" height="20" width="89">Cost Structure</TD><TD class="xl65" width="84">Total Amount</TD></TR><TR><TD height="20">Gas</TD><TD align="right" class="xl66">2,918,655</TD></TR><TR><TD height="20">Depresiasi</TD><TD align="right" class="xl66">2,895,706</TD></TR></TBODY></TABLE><P></P><P>Gas is From Amount W4CC15BU00 + <SPAN style="font-size: 13.6000003814697px;">W4CC14AF00 + <SPAN style="font-size: 13.6000003814697px;">W4CC15BN00 + <SPAN style="font-size: 13.6000003814697px;">W4CC17CQ00, but all of them is distinct by W4CC.</SPAN></SPAN></SPAN></P><P></P><P>Please help!</P><P></P><P>Thanks</P><P><BR />Regards,</P><P></P><P>Paulus Indra Salim.</P></BODY></HTML> Wed, 08 Oct 2014 03:48:57 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/Aggregation-Distinct/m-p/677083#M439 2014-10-08T03:48:57Z Re: Aggregation Distinct https://community.qlik.com/t5/Qlik-Learning-Discussions/Aggregation-Distinct/m-p/677084#M440 <HTML><HEAD></HEAD><BODY><P>Is this?</P><P>Only you need, in the select put DISTINCT </P><P><IMG alt="p05.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/68468_p05.png" style="width: 620px; height: 269px;" /></P><P></P><P>LOAD <STRONG>distinct</STRONG></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; COST_STRUCTURE,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Amount,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; W4CC</P><P>FROM</P><P><SPAN>[</SPAN><A class="jive-link-thread-small" data-containerid="2129" data-containertype="14" data-objectid="136835" data-objecttype="1" href="http://community.qlik.com/thread/136835">http://community.qlik.com/thread/136835</A><SPAN>]</SPAN></P><P>(html, codepage is 1252, embedded labels, table is @1);</P></BODY></HTML> Wed, 08 Oct 2014 04:16:00 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/Aggregation-Distinct/m-p/677084#M440 ecolomer 2014-10-08T04:16:00Z