topic Summary values when grouping data in QlikView https://community.qlik.com/t5/QlikView/Summary-values-when-grouping-data/m-p/19682#M783302 <HTML><HEAD></HEAD><BODY><P>how do i get summary values shown in a table?</P><P>i.e.</P><P>i want to show information for a range or customer order numbers, each of which has more than one line.</P><P>i want to see...</P><P>order no - part no - qty - price - value</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2.0&nbsp;&nbsp;&nbsp;&nbsp; 2.0</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3.0&nbsp;&nbsp;&nbsp;&nbsp; 6.0</P><P>summary 8.0</P><P></P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2.0&nbsp;&nbsp;&nbsp;&nbsp; 2.0</P><P>summary 2.0</P><P></P><P>etc.</P><P></P><P>is this possible?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT clickertape 2020-11-25T16:16:04Z Summary values when grouping data https://community.qlik.com/t5/QlikView/Summary-values-when-grouping-data/m-p/19682#M783302 <HTML><HEAD></HEAD><BODY><P>how do i get summary values shown in a table?</P><P>i.e.</P><P>i want to show information for a range or customer order numbers, each of which has more than one line.</P><P>i want to see...</P><P>order no - part no - qty - price - value</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2.0&nbsp;&nbsp;&nbsp;&nbsp; 2.0</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3.0&nbsp;&nbsp;&nbsp;&nbsp; 6.0</P><P>summary 8.0</P><P></P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2.0&nbsp;&nbsp;&nbsp;&nbsp; 2.0</P><P>summary 2.0</P><P></P><P>etc.</P><P></P><P>is this possible?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Summary-values-when-grouping-data/m-p/19682#M783302 clickertape 2020-11-25T16:16:04Z Re: Summary values when grouping data https://community.qlik.com/t5/QlikView/Summary-values-when-grouping-data/m-p/19683#M783303 <HTML><HEAD></HEAD><BODY><P>You can use Partial Sum in pivot table to have sub totals, please elaborate in which chart you are trying this?</P></BODY></HTML> Tue, 13 Mar 2018 15:30:16 GMT https://community.qlik.com/t5/QlikView/Summary-values-when-grouping-data/m-p/19683#M783303 Digvijay_Singh 2018-03-13T15:30:16Z Re: Summary values when grouping data https://community.qlik.com/t5/QlikView/Summary-values-when-grouping-data/m-p/19684#M783304 <HTML><HEAD></HEAD><BODY><P>PFA,</P></BODY></HTML> Tue, 13 Mar 2018 16:27:11 GMT https://community.qlik.com/t5/QlikView/Summary-values-when-grouping-data/m-p/19684#M783304 Nagaraju_KCS 2018-03-13T16:27:11Z Re: Summary values when grouping data https://community.qlik.com/t5/QlikView/Summary-values-when-grouping-data/m-p/19685#M783305 <HTML><HEAD></HEAD><BODY><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/196209_Capture.JPG" style="height: auto;" /></P><P>Put one expression as summary</P><P></P><P>aggr(sum(value),[order no])</P></BODY></HTML> Tue, 13 Mar 2018 16:44:03 GMT https://community.qlik.com/t5/QlikView/Summary-values-when-grouping-data/m-p/19685#M783305 shiveshsingh 2018-03-13T16:44:03Z