Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I've got a few variable input boxes that allows the user to filter patients in a healthcare application.
One filter is for # of admissions. The field Admission_Flag is either 1 or 0, and the variable v_Admissions is the number of admissions entered into the input box. When a value is entered, this expression is executed and MRN numbers are selected. This runs slow and I would like to improve the performance. Any ideas?
='(' & Concat({<[Patient MRN]=,PayorName=,[Payor GL]=,[Payor Level 1]=,[Payor Level 2]=,[Payor Level 3]=>}if(aggr(sum({<[Patient MRN]=,PayorName=,[Payor GL]=,[Payor Level 1]=,[Payor Level 2]=,[Payor Level 3]=>}
Admission_Flag),[Patient MRN])>= v_Admissions, [Patient MRN]), '|') & ')'
Thanks!
Try this:
='(' & Concat({<[Patient MRN]={'=sum({<[Patient MRN]=,PayorName=,[Payor GL]=,[Payor Level 1]=,[Payor Level 2]=,[Payor Level 3]=>}Admission_Flag)>=$(v_Admissions)'},PayorName=,[Payor GL]=,[Payor Level 1]=,[Payor Level 2]=,[Payor Level 3]=>} [Patient MRN]), '|') & ')'
Whiteline, thanks for the reponse. I'm not sure why, but I am unable to get your expression to make any selections on [Patient MRN].
It's not clear what you're trying to achieve.
I thought it's the point since you reset the selections in your original expression.
Remove the [Patient MRN]=, under the sum() set analysis.
If the user enters admissions >= 2, then decided to change that to >=1, the selections have to be reset, so in the expression I am saying [Patient MRN]= so the current selection does not affect the selection that is being made. This is a bit complicated and I'm probably not explaining it as best as I can. Hopefully this helps.
Could you upload brief sample ?
I've attached a very simple example. Please let me know what questions you might have.
This works really quick on a small data set.
Hi
Please use below expression in test Application
='(' &
Concat({<PAT_MRN=,PAT_MRN={"=sum({<[PAT_MRN]=>}ADMIT_FLAG))>= v_Admissions"}>} [PAT_MRN], '|') & ')'
Regards,
Perumal A
Thanks for the response Perumal.
When I apply that expression to the variable trigger (both on input and change) there are no selections made to PAT_MRN. The ADMIT_FLAG has to be summed by MRN to select those who are greater than or equal to the input field (v_Admissions).
Hi
For me wroking .PFA sample application.