topic Sum of Rows in a Text Box in QlikView https://community.qlik.com/t5/QlikView/Sum-of-Rows-in-a-Text-Box/m-p/67780#M781068 <HTML><HEAD></HEAD><BODY><P>How do I get Sum of Rows value on a Expression/Field from Straight Table in a Text Box?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT qlikwiz123 2020-11-25T16:16:04Z Sum of Rows in a Text Box https://community.qlik.com/t5/QlikView/Sum-of-Rows-in-a-Text-Box/m-p/67780#M781068 <HTML><HEAD></HEAD><BODY><P>How do I get Sum of Rows value on a Expression/Field from Straight Table in a Text Box?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Sum-of-Rows-in-a-Text-Box/m-p/67780#M781068 qlikwiz123 2020-11-25T16:16:04Z Re: Sum of Rows in a Text Box https://community.qlik.com/t5/QlikView/Sum-of-Rows-in-a-Text-Box/m-p/67781#M781069 <HTML><HEAD></HEAD><BODY><P>It depends on what dimensions and expressions you are using in your straight table.</P><P>Can you provide dimensions and expressions here?</P></BODY></HTML> Wed, 21 Mar 2018 20:48:24 GMT https://community.qlik.com/t5/QlikView/Sum-of-Rows-in-a-Text-Box/m-p/67781#M781069 MK_QSL 2018-03-21T20:48:24Z Re: Sum of Rows in a Text Box https://community.qlik.com/t5/QlikView/Sum-of-Rows-in-a-Text-Box/m-p/67782#M781070 <HTML><HEAD></HEAD><BODY><P>QW,</P><P>You could use the aggr() function inside a sum() to get the same result as a sum of rows in a table.&nbsp; The aggr() would calculate the expression for each combination of dimension values - just like straight table does.</P><P></P><P>I hope that helps. </P></BODY></HTML> Wed, 21 Mar 2018 20:50:13 GMT https://community.qlik.com/t5/QlikView/Sum-of-Rows-in-a-Text-Box/m-p/67782#M781070 john_obrien 2018-03-21T20:50:13Z Re: Sum of Rows in a Text Box https://community.qlik.com/t5/QlikView/Sum-of-Rows-in-a-Text-Box/m-p/67783#M781071 <HTML><HEAD></HEAD><BODY><P>The Expression is a simple Count(Field) but there are many dimensions in the Straight Table. Should I list all the dimensions under Aggr() ? I don't show all the Dimensions at once. What happens then.</P></BODY></HTML> Wed, 21 Mar 2018 20:54:43 GMT https://community.qlik.com/t5/QlikView/Sum-of-Rows-in-a-Text-Box/m-p/67783#M781071 qlikwiz123 2018-03-21T20:54:43Z Re: Sum of Rows in a Text Box https://community.qlik.com/t5/QlikView/Sum-of-Rows-in-a-Text-Box/m-p/67784#M781072 <HTML><HEAD></HEAD><BODY><P>You can use something like this</P><P></P><P>SUM(Aggr(Count(Field),Dim1,Dim2,Dim3))</P><P>Add all your dimensions inside aggr.</P></BODY></HTML> Wed, 21 Mar 2018 20:58:20 GMT https://community.qlik.com/t5/QlikView/Sum-of-Rows-in-a-Text-Box/m-p/67784#M781072 MK_QSL 2018-03-21T20:58:20Z Re: Sum of Rows in a Text Box https://community.qlik.com/t5/QlikView/Sum-of-Rows-in-a-Text-Box/m-p/67785#M781073 <HTML><HEAD></HEAD><BODY><P>You selected your answer as correct??? </P></BODY></HTML> Wed, 21 Mar 2018 21:18:40 GMT https://community.qlik.com/t5/QlikView/Sum-of-Rows-in-a-Text-Box/m-p/67785#M781073 MK_QSL 2018-03-21T21:18:40Z Re: Sum of Rows in a Text Box https://community.qlik.com/t5/QlikView/Sum-of-Rows-in-a-Text-Box/m-p/67786#M781074 <HTML><HEAD></HEAD><BODY><P>Strange <IMG src="https://community.qlik.com/legacyfs/online/emoticons/grin.png" /></P></BODY></HTML> Thu, 22 Mar 2018 06:13:55 GMT https://community.qlik.com/t5/QlikView/Sum-of-Rows-in-a-Text-Box/m-p/67786#M781074 shiveshsingh 2018-03-22T06:13:55Z