Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Why not add the year to you expression?
Count({<CPT={'99201','99202','99203','99204','99205'}, Year = {2017}>}Distinct PATIENTID)
Why not add the year to you expression?
Count({<CPT={'99201','99202','99203','99204','99205'}, Year = {2017}>}Distinct PATIENTID)
Even better, it worked. Thanks so Much.
HI,
How do I write the expression but for a specific date range instead of year...like Jan-Oct 2017?
Do you have a date or monthyear field? What is it called?
Yeah its called "Month Year".
Can you share the script used to create it in the back end of the app?
Date(MonthStart("Transaction Date"),'MMMM YYYY') as "Month Year",
May be this
Count({<CPT={'99201','99202','99203','99204','99205'}, [Month Year]= {"$(='>=' & Date(YearStart(Max([Month Year])), 'MMMM YYYY') & '<=' & Date(Max([Month Year]), 'MMMM YYYY'))"}>} Distinct PATIENTID)