topic TOP graph in App Development https://community.qlik.com/t5/App-Development/TOP-graph/m-p/126552#M8859 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en">I need to bring the sum of the sale of the 25 biggest products in the graph I have below a formula that me in the table that value, but I need to put in the graph that with the dimension of year-month and is not working.</SPAN></P><P><BR />(<BR />sum(</P><P>&nbsp; aggr(</P><P>&nbsp; if(rank(sum({&lt;TIPO={'VENTA NETA FINANCEIRA'}&gt;} VALOR))&lt;= 25<BR />&nbsp; sum({&lt;TIPO={'VENTA NETA FINANCEIRA'}&gt;} VALOR))</P><P>&nbsp; ,[DESCRIPCIÓN]</P><P>&nbsp; )</P><P>))/1000</P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/213520_pastedImage_1.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Thu, 13 Sep 2018 19:36:39 GMT kevin_santos 2018-09-13T19:36:39Z TOP graph https://community.qlik.com/t5/App-Development/TOP-graph/m-p/126552#M8859 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en">I need to bring the sum of the sale of the 25 biggest products in the graph I have below a formula that me in the table that value, but I need to put in the graph that with the dimension of year-month and is not working.</SPAN></P><P><BR />(<BR />sum(</P><P>&nbsp; aggr(</P><P>&nbsp; if(rank(sum({&lt;TIPO={'VENTA NETA FINANCEIRA'}&gt;} VALOR))&lt;= 25<BR />&nbsp; sum({&lt;TIPO={'VENTA NETA FINANCEIRA'}&gt;} VALOR))</P><P>&nbsp; ,[DESCRIPCIÓN]</P><P>&nbsp; )</P><P>))/1000</P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/213520_pastedImage_1.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Thu, 13 Sep 2018 19:36:39 GMT https://community.qlik.com/t5/App-Development/TOP-graph/m-p/126552#M8859 kevin_santos 2018-09-13T19:36:39Z