Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

kevin_santos
New Contributor

TOP graph

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.


(
sum(

  aggr(

  if(rank(sum({<TIPO={'VENTA NETA FINANCEIRA'}>} VALOR))<= 25
  sum({<TIPO={'VENTA NETA FINANCEIRA'}>} VALOR))

  ,[DESCRIPCIÓN]

  )

))/1000