topic How to do aggregation in Chart - table in QlikView https://community.qlik.com/t5/QlikView/How-to-do-aggregation-in-Chart-table/m-p/1159448#M886819 <HTML><HEAD></HEAD><BODY><OL style="list-style-type: upper-roman;"><LI><SPAN style="font-size: 14.0pt; font-family: 'Times New Roman','serif';">I want to represent data in the (Data_1 --&gt; </SPAN><SPAN style="font-size: 14.0pt; font-family: 'Times New Roman','serif';">Sheet 1 ) as (Data_1 --&gt; </SPAN><SPAN style="font-size: 14.0pt; font-family: 'Times New Roman','serif';">Sheet2).</SPAN></LI><LI><SPAN style="font-size: 14.0pt; font-family: 'Times New Roman','serif';"><IMG alt="2.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/136685_2.png" style="height: 510px; width: 620px;" /><IMG alt="1.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/136672_1.PNG" style="height: auto;" /></SPAN></LI><LI></LI></OL></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT soloeeeoff 2020-11-25T16:16:04Z How to do aggregation in Chart - table https://community.qlik.com/t5/QlikView/How-to-do-aggregation-in-Chart-table/m-p/1159448#M886819 <HTML><HEAD></HEAD><BODY><OL style="list-style-type: upper-roman;"><LI><SPAN style="font-size: 14.0pt; font-family: 'Times New Roman','serif';">I want to represent data in the (Data_1 --&gt; </SPAN><SPAN style="font-size: 14.0pt; font-family: 'Times New Roman','serif';">Sheet 1 ) as (Data_1 --&gt; </SPAN><SPAN style="font-size: 14.0pt; font-family: 'Times New Roman','serif';">Sheet2).</SPAN></LI><LI><SPAN style="font-size: 14.0pt; font-family: 'Times New Roman','serif';"><IMG alt="2.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/136685_2.png" style="height: 510px; width: 620px;" /><IMG alt="1.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/136672_1.PNG" style="height: auto;" /></SPAN></LI><LI></LI></OL></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-do-aggregation-in-Chart-table/m-p/1159448#M886819 soloeeeoff 2020-11-25T16:16:04Z Re: How to do aggregation in Chart - table https://community.qlik.com/t5/QlikView/How-to-do-aggregation-in-Chart-table/m-p/1159449#M886820 <HTML><HEAD></HEAD><BODY><P>Is this you are expecting?</P><P></P><P><SPAN style="text-decoration: underline;"><STRONG>I've update new one, My muistake</STRONG></SPAN></P></BODY></HTML> Wed, 07 Sep 2016 15:31:34 GMT https://community.qlik.com/t5/QlikView/How-to-do-aggregation-in-Chart-table/m-p/1159449#M886820 Anil_Babu_Samineni 2016-09-07T15:31:34Z Re: How to do aggregation in Chart - table https://community.qlik.com/t5/QlikView/How-to-do-aggregation-in-Chart-table/m-p/1159450#M886821 <HTML><HEAD></HEAD><BODY><P>Another option would be to create three new expressions like this:</P><P></P><P><STRONG>=Sum(Mark1)/Sum(TOTAL Mark1)</STRONG></P><P><STRONG>=Sum(Mark2)/Sum(TOTAL Mark2)</STRONG></P><P><STRONG>=Sum(Mark3)/Sum(TOTAL Mark3)</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/136728_Capture.PNG" style="height: 191px; width: 620px;" /><BR /></STRONG></P></BODY></HTML> Wed, 07 Sep 2016 19:26:04 GMT https://community.qlik.com/t5/QlikView/How-to-do-aggregation-in-Chart-table/m-p/1159450#M886821 sunny_talwar 2016-09-07T19:26:04Z Re: How to do aggregation in Chart - table https://community.qlik.com/t5/QlikView/How-to-do-aggregation-in-Chart-table/m-p/1159451#M886822 <HTML><HEAD></HEAD><BODY><P>Dear Anil,</P><P>Can you please tell me what is the difference between </P><P>1. Sum(Mark1)</P><P>2. Sum( All Mark1)</P><P>3. Sum(Total Mark1)</P><P>4. Sum(Distinct Mark1)</P><P>5. Sum(${Mark1} Mark1)</P></BODY></HTML> Thu, 08 Sep 2016 02:57:09 GMT https://community.qlik.com/t5/QlikView/How-to-do-aggregation-in-Chart-table/m-p/1159451#M886822 soloeeeoff 2016-09-08T02:57:09Z Re: How to do aggregation in Chart - table https://community.qlik.com/t5/QlikView/How-to-do-aggregation-in-Chart-table/m-p/1159452#M886823 <HTML><HEAD></HEAD><BODY><P>I recommend you start your self by hand then you will get more clarification. please find attachment then observe, Which is make sense... <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P><STRONG style="text-decoration: underline;">With %</STRONG></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/136786_Capture.PNG" style="height: 179px; width: 620px;" /></P><P></P><P><STRONG style="text-decoration: underline;">Without %</STRONG></P><P></P><P><IMG alt="Capture1.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/136787_Capture1.PNG" style="height: 182px; width: 620px;" /></P></BODY></HTML> Thu, 08 Sep 2016 06:22:00 GMT https://community.qlik.com/t5/QlikView/How-to-do-aggregation-in-Chart-table/m-p/1159452#M886823 Anil_Babu_Samineni 2016-09-08T06:22:00Z