Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
alexandernatale
Creator II
Creator II

Set analysis AND and OR in healthcare example

Good morning,

I am unable to calculate an indicator relating to some interventions in the healthcare field.

In particular, my goal is to calculate the number of interventions that have the following characteristics:
all hospitalizations with main and secondary diagnoses (5 fields) with ICD-9-CM codes 174.x, 198.81, 233.0 and
interventions for breast cancer defined by at least one of the ICD-9-CM codes in any position (5 fields): 85.2x, 85.33-85.36,85.4x.

How can I set up set analysis?

This is my "trace":
count(
{<
Year={$(=max(Year))},
type={'1', '4'},
priority={"A"},
principal_diagn = {$(cod_diagnosys)},
principal_int = {$(cod_int)}
>
id)

any suggestion?

Thanks

Labels (1)
0 Replies