4 Replies Latest reply: Apr 27, 2017 9:10 AM by Martín Caruso RSS

    Count of records

    Martín Caruso

      Good afternoon, I'm new to the development of Qlik Sense.

      I have two problems that are complicating me to solve in a table with the following values:

       

      %CAMPO_CLAVECAMPO_SUM_1CAMPO_SUM_2PORC
      4500211977-000109.523.140,009.513.009,00939,00%
      4500055052-00030980,00880,008,80%
      4500214540-001202.707,802.256,555,00%
      4500210678-0006014.024,109.349,402,00%
      4500146228-000100,00-5.413,16-1,00%
      4500157376-001000,00-1.350,00-1,00%
      4500092220-00030950,00--

       

      1) On the one hand, I need to show only records that have values in all their fields. The record for %CAMPO_CLAVE = 4500092220-00030, should not be displayed. In [Add-ons / Data handling /] I have detildada the option of ''Show zero values''.


      2) On the other hand, it should show in the table only the records where the PORC is greater than 2.00%. As I did not find the option to carry out this action. I decided to show in indicators the number of records where PORC> 2.00% (records in red) and where PORC <2,00% (records in green). The expression I am using is the following, but the result it gives me is the total count to all the records (ie, 7).

      Count

        (

        Aggr

                (

                If($(vDif_Porc) > '0,02', 1, 0)

                , [%CAMPO_CLAVE]

                )

        )

       

      I appreciate any help or guidance you can give me about it.

      Regards!