2 Replies Latest reply: Jan 4, 2018 11:55 AM by Filipe Gomes RSS

    Getting the value I want on the Totals of a Table but not on the right row

    Filipe Gomes



      I have the following table on Qlik Sense:



      To calculate "Número de Avarias Cumulativas por Ano" I have this formula:

      Aggr(Count(Ordem), [Equipamento-Num. SAP])


      For "Taxa de Falha" I have this:

      Aggr(Count(Ordem), [Equipamento-Num. SAP])/((Max({<Factory=, Unidade=, [Nome Equipamento]=, [TAG.Nr]=, Boundary=>}(Data))-MakeDate(2008,01,01))*24/pow(10,6))


      I have to use {<Factory=, Unidade=, [Nome Equipamento]=, [TAG.Nr]=, Boundary=>} to avoid filters from removing the latest date, since I have no records for the last day I am filtering.


      The value I must have for B10-UTL is 28,53. The value that appears on the Totals. Why cannot I have that value for B10-UTL?


      Thank you for your answers.


      Best regards,