5 Replies Latest reply: Jul 28, 2016 12:17 PM by Clever Anjos RSS

    Problem with Sum and Set Analisys

    Ronald Bertele

      I have a table with many rows

       

      Format Data = DD/MM/YYYY

       

      Fields:     Data                <>      Pontos Possiveis      <>      Pontos Conquistados

      Rows:     01/01/2016                20                                        10    

                     01/02/2016                20                                        20     

       

      I have this expression


      Sum({<Mês=,Ano=,Data={"=$(vDataPesquisaRED)"}>} [Pontos Conquistados)

      /

      Sum({<Mês=,Ano=,Data={"=$(vDataPesquisaRED)"}>} [Pontos Possiveis])

       

      The variable vDataPesquisaRED return the Max Date

       

      The result would be 1, because (20 / 20)

       

      But my results is 0,75, because (30 / 40)

       

      I don't know why the Qlik return 0,75, the correct is 1

       

      Can someone help me?


      Kind regards