7 Replies Latest reply: Jul 27, 2017 9:25 PM by Srikanth P RSS

    Qlik Sense: Convert CountIF to Set Analysis

    Steven Demny

      Hi Community,

       

      I have a Count IF statement that tells me the percentage of Specialist visits that happen before a reporting date.  It works fine.

      Count(If(ClientReportingDate>=ClaimDt, Specialist)) / Count(Total(If(ClientReportingDate>=ClaimDt, Specialist)))

       

      I am trying to convert it to Set Analysis to increase app performance.  Here is the equation I've tried, but it doesn't work.

      Count({$<ClientReportingDate={'>=ClaimDt'}>}Specialist) / Count({1<ClientReportingDate={'>=ClaimDt'}>}Specialist)

       

      When just looking at the numerator, it doesn't work.

      Count({$<ClientReportingDate={'>=ClaimDt'}>}Specialist)


      I looked through a lot of forums but can't seem to find what works in Qlik Sense.  What am I missing?  I appreciate your help!


      -SD