topic Re: Sum all from graph. in QlikView https://community.qlik.com/t5/QlikView/Sum-all-from-graph/m-p/438309#M488187 <HTML><HEAD></HEAD><BODY><P>Thanks bro.</P><P></P><P>U help me well....</P></BODY></HTML> Mon, 21 Jan 2013 10:09:27 GMT 2013-01-21T10:09:27Z Sum all from graph. https://community.qlik.com/t5/QlikView/Sum-all-from-graph/m-p/438307#M488185 <HTML><HEAD></HEAD><BODY><P>Hello guys,</P><P></P><P>I have problem to show in text(in presentation) the total of no ticket for all parcel. now i'm just using count(parcelid) to come out the graph. any ideas to sum the num from the graph attach. thanks.</P></BODY></HTML> Mon, 21 Jan 2013 09:49:01 GMT https://community.qlik.com/t5/QlikView/Sum-all-from-graph/m-p/438307#M488185 2013-01-21T09:49:01Z Re: Sum all from graph. https://community.qlik.com/t5/QlikView/Sum-all-from-graph/m-p/438308#M488186 <HTML><HEAD></HEAD><BODY><P>Try using an advanced aggregation (i.e. aggr() function), maybe:</P><P></P><P>=sum( aggr( count(parcelid), location))</P><P></P><P>where location is the field you used as dimension in your chart (needs to be a field, no calculated dimension).</P><P></P><P>Hope this helps,</P><P>Stefan</P></BODY></HTML> Mon, 21 Jan 2013 09:52:46 GMT https://community.qlik.com/t5/QlikView/Sum-all-from-graph/m-p/438308#M488186 swuehl 2013-01-21T09:52:46Z Re: Sum all from graph. https://community.qlik.com/t5/QlikView/Sum-all-from-graph/m-p/438309#M488187 <HTML><HEAD></HEAD><BODY><P>Thanks bro.</P><P></P><P>U help me well....</P></BODY></HTML> Mon, 21 Jan 2013 10:09:27 GMT https://community.qlik.com/t5/QlikView/Sum-all-from-graph/m-p/438309#M488187 2013-01-21T10:09:27Z