Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
JRoz_DataUnicorn
Explorer II
Explorer 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)

0 Replies