2 Replies Latest reply: Feb 16, 2018 2:36 AM by Jonnie Yacoub RSS

    Formula in KPI visualization

    Jonnie Yacoub

      Hey Qlikkers,

       

      Im trying to get the following expression in one KPI visualization. Is it possible to get the first two set analysis counts in one?

       

      count({<[type]={'deal'},

      [source]-={'Via verhuurder'},

      [date]={'>=01/03/2017'}>}

      [type])

      +

      COUNT(DISTINCT{<[fee_type]={'commission'},

      status_contract_renter_signed={'>=01/03/2017'},

      client_contract_status={'final'}>}

      client_contract)

      /

      Count({<[type]={'lead'},

      source -={'Via verhuurder','Eerder geholpen'},

      date={">=01/03/2017"}>}

      type)

        • Re: Formula in KPI visualization
          Michael Tarallo

          Hi Jonnie, (just to get some clarity)

           

          Thanks for your question. Are you trying to just reduce the formula to make it easier to read?

          Are you having any issues with the result, or is the result OK?

           

          Thanks

           

          When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

           

          Regards,

           

          Mike T

          Qlik

            • Re: Formula in KPI visualization
              Jonnie Yacoub

              hi sir Tarello,

               

              The formula is working but it is showing the wrong result. I want to show the conversion rate %...

              The formula below shows me the right result. but when i want to devide these counts by an other count, it gives me the wrong result

              count({<[type]={'deal'},

              [source]-={'Via verhuurder'},

              [date]={'>=01/03/2017'}>}

              [type])

              +

              COUNT(DISTINCT{<[fee_type]={'commission'},

              status_contract_renter_signed={'>=01/03/2017'},

              user_id={'*'},

              client_contract_status={'final'}>}

              client_contract)