Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

VFE- MEL expression for either or IF statement?

CPS, C-EMR, PM

Last Post by Anonymous 1 second ago

9 Posts

6 Users

0 Reactions

160 Views

RSS

Jude

(@judea)

Posts: 91

Estimable Member

Topic starter

Hi all, I am developing STOP-Bang questionnaire form in VFE. I am missing something because I can't get this function to work

{ IF DOCUMENT.BANGSTORE >2 AND DOCUMENT.BANGSTORE <5 then
DOCUMENT.BANGRESULT = "OSA - Intermediate Risk"
else
IF DOCUMENT.BANGSTORE >=2 AND DOCUMENT.BODYMASS =Yes then
DOCUMENT.BANGRESULT = "OSA - High Risk"
else
IF DOCUMENT.BANGSTORE >=2 AND DOCUMENT.FOR_MALE =Yes then
DOCUMENT.BANGRESULT = "OSA - High Risk"

else ""
endif endif endif}

It is only taking the first statement. it does not recognize the other two statements if other answers are yes.

Any thoughts?

Thanks, Jude

Posted : September 26, 2018 3:58 am

joeg1962

(@joeg1962)

Posts: 843

Noble Member

Just thinking a bit about this... and wondering if you need to be doing VAL on those numeric document variables?

{ IF VAL(DOCUMENT.BANGSTORE) >2 AND VAL(DOCUMENT.BANGSTORE) <5 then ...

Also, the text for Yes probably needs to be in quotes "Yes"

Posted : September 26, 2018 4:20 am

Jude

(@judea)

Posts: 91

Estimable Member

Topic starter

Still doing the same thing with VAL or without VAL. It is only recognizing the first IF sentence.

Posted : September 26, 2018 4:42 am

joeg1962

(@joeg1962)

Posts: 843

Noble Member

Perhaps simplify - remove the 3rd if, and change the 2nd if to just say "two".

That way, you can make sure it is analyzing to that point.

Once there, use a simple if - like if 2>1 then "TWO"

Simply step through it all.

And one last thing, sometimes manually retyping helps, eliminating a random and unintended character. By the way, assuming you are using the VAL and "quotes", the logic looks correct to me. Although, it is obviously not your true cut/paste.

Posted : September 26, 2018 4:52 am

amaskey

(@amaskey)

Posts: 88

Estimable Member

if document.bangstore is 3 or 4, it will always execute only the first statement and ignore the other two statements

Posted : September 26, 2018 6:44 am

joeg1962

(@joeg1962)

Posts: 843

Noble Member

That is correct -> if bangstore is 3 or 4 it will ALWAYS stop there. It meets the first rule so NEVER gets to any succeeding rules. If you want a different result, then perhaps re-order your statements?

Posted : September 26, 2018 7:07 am

ljk001

(@ljk001)

Posts: 5

Active Member

Yes, reordering the statements will work . Code the document.bangstore is 3 or 4 as the 3rd if then else statement.

Posted : September 26, 2018 8:24 am

chaddix

(@chaddix)

Posts: 177

Estimable Member

A few things I noticed (my attempt at a re-write is below):
1. Rather than IF/ELSE IF/ELSE IF, I recommend a cond case endcond statement. It really helps simplify the code and makes it easier to think through.

2. By default, I think MEL treats all DOCUMENT. variables as strings, so I think you need to use VAL(DOCUMENT.BANGSTORE) in evaluations.

3. When checking for value = yes, you need to put the Yes in double-quotes. I also use a double == for evaluations like this one, but that could just be personal preference.

{
cond
case VAL(DOCUMENT.BANGSTORE) >2 AND VAL(DOCUMENT.BANGSTORE) =2 AND DOCUMENT.BODYMASS == "Yes": DOCUMENT.BANGRESULT = "OSA – High Risk"
case VAL(DOCUMENT.BANGSTORE) >=2 AND DOCUMENT.FOR_MALE == "Yes": DOCUMENT.BANGRESULT = "OSA – High Risk"
else: //do nothing
endcond
}

Posted : September 26, 2018 9:22 am

DavidShower

(@davidshower)

Posts: 1255

Noble Member

So here's what I found about the scoring on a quick web search:

For general population

Low risk of OSA: Yes to 0-2 questions

Intermediate risk of OSA: Yes to 3-4 questions

High risk of OSA: Yes to 5-8 questions

or Yes to 2 or more of 4 STOP questions + male gender

or Yes to 2 or more of 4 STOP questions + BMI > 35 kg/m2

or Yes to 2 or more of 4 STOP questions + neck circumference (17”/43cm in male, 16”/41cm in female)

So I would take Chaddix's suggestion and write this as COND..CASE..ELSE..ENDCOND. Conditional statements like this quit executing as soon as one of the CASE statements is true, so I would do a CASE statement for each High Risk scenarios first, then your Intermediate Risk, and Low Risk would be assigned as the ELSE.

Posted : September 28, 2018 12:20 pm

Share:

24 Forums
9,940 Topics
39.9 K Posts
1 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.0