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

      Hi,

       

      I have the following table on Qlik Sense:

      Capture.PNG

       

      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,