8 Replies Latest reply: Dec 8, 2017 11:06 AM by Sunny Talwar RSS

    Set Modifier used with a Variable

    Ashley Kuttler

      I am new to Qlik and I am having trouble with an expression:

       

      1) Sum({$<Year={2017}>}$(VCountNewPatients))

       

      Where vCountNewPatients = Count({<CPT={'99201','99202','99203','99204','99205'}>}Distinct PATIENTID)

       

      I am trying to sum the #  of New Patients in 2017. But 1) expression comes back as null.

       

      CPT =99201','99202','99203','99204','99205 refers to New Patient office visits .


      I cant figure how to use a set a modifier with the CountNewPatients Variable.