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.