Qlik Community

Qlik Healthcare User Group

A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights.

Highlighted
JRoz_DataUnicorn
Visitor II

Count encounters whereas the sum of charges >0

Hi, I have been using qlikview for awhile now, but I am by no means an expert. I have a situation whereas when I add the encounter key I get the results I want when I remove it from the dimensions it does no longer work. Below I am trying to sum a count based on a charge qty within each encounter ID that the charges are > 0.

Variable Obscriteria holds my criteria for my type of patients = visit type, revenue line etc.. It does not exclude where charges are <=0, I could not get it to work in my script that way.

Below is my counter. Please let me know what I can do. I appreciate it.

if(sum({$<MonthYear=,
[Fiscal Year] = {$(vFYCurrent)},
[Discharge Date]={'<=$(vMaxDate)'},
$(vObsCriteria),
[Encounter ID]
>}
[Charge Quantity])
sum({$<
MonthYear=,
[Fiscal Year] = {$(vFYCurrent)},
[Discharge Date]={'<=$(vMaxDate)'},
$(vObsCriteria)
>}
EncounterCount),0)

Tags (1)