Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Why does the following expression not count only ID=1:
Expression: count({<condition={'obese'}>*<condition={'DM'}>*<condition={'HTN'}>} distinct patient)
Dimension: Valuelist('HTN | DM | Obese','Obese','HTN','DM','HTN | DM','HTN | Obese','DM | Obese')
Here's my data (qvf attached):
load * inline [
condition, ID
'obese',1
'HTN', 1
'DM',1
'obese',2
'HTN',2
'obese',3
'obese',4
'obese',5
'DM',5
'DM',6
'HTN',7
'obese',8
];
I figured out a solution. This worked for me:
count({<ID=P({<condition={'obese'}>}ID)>*<ID=P({<condition={'HTN'}>}ID)>*<ID=P({<condition={'DM'}>}ID)>} distinct ID)
I figured out a solution. This worked for me:
count({<ID=P({<condition={'obese'}>}ID)>*<ID=P({<condition={'HTN'}>}ID)>*<ID=P({<condition={'DM'}>}ID)>} distinct ID)