Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
jwbadger3
Contributor II
Contributor II

Qlik Epic Radar Integrations and Activity Links

Howdy folks,

Has any other organization found the definitive way to launch any E2N activity within hyperspace from a QV app? Epic has confirmed this is possible but they have not released how you pass E2N desired/required fields beyond just the Patient ID.

We created a document with the basic information (see attached) but we wanted to extend to encounter specific activities.

Labels (1)
25 Replies
joe_warbington
Partner - Creator III
Partner - Creator III

Thanks Jeff!

Here's what I typically reference when working on the QlikView Epic Integrations:

1. In a QlikView straight table object, create a new expression that will be used to launch an Epic activity.
2. Label the expression appropriately and enter definition code such as (this includes code to pad the patient IDs which may be necessary):

='Launch Chart Review'&'<URL>EpicAct:UCW_CHART_REVIEW,InfoName:PATIENTID,InfoValue:'& REPEAT(' ', (10 - LEN(PAT_ID))) & PAT_ID


Or


='Launch Snapshot'&'<URL>EpicAct:UCW_SNAPSHOT,InfoName:PATIENTID,InfoValue:'& REPEAT(' ', (10 - LEN(PAT_ID))) & PAT_ID


3. Set the Display Options for Representation to Link.

4. Host the application in Hyperspace using the QlikView Radar integrations. This could be a Link Component that links out to the QlikView Access Point or the specific application in question. Or it could be a Native HTML component that displays a particular QlikView application or single object from an application.


Examples of testing links for Radar to the QlikView applications:

Full QlikView Application: OpenDoc mode including optional selections:

http://eu-b.demo.qlik.com/QvAJAXZfc/opendoc.htm?document=qvdocs/Prescription%20Tracker.qvw&host=Demo...   


Single object: SingleObject mode including optional selections:

http://eu-b.demo.qlik.com/QvAJAXZfc/singleobject.htm?document=qvdocs/Prescription%20Tracker.qvw&host...  


The singleobject mode is nice because it automatically responds to the size of the viewport. If you choose the opendoc mode, you'd need to make the dimensions similar so that things scale and are still readable without scroll bars.


The host and anonymous parameters are also optional.


--


OTHER TOKENS TO HYPERLINK INTO HYPERSPACE

- Chart Review: UCW_CHART_REVIEW

- SnapShot: UCW_SNAPSHOT

- Review Flowsheets: UCW_REVIEW_FLOWSHEETS

- Results Review: UCW_RESULTS_REVIEW

- Allergies/Contraindications: UCW_ALLERGIES

- History: UCW_HISTORY

- Problem List: UCW_PROBLEM_LIST

- Radiation Summary: RIS_RADIATION_TRACKING

- Breast Care Summary: RIS_MAMMO_PATIENT_STORY

HYPERLINK_TOKENS:

LOAD * INLINE [

    Description,Token

    Chart Review,UCW_CHART_REVIEW

    SnapShot,UCW_SNAPSHOT

    Review Flowsheets,UCW_REVIEW_FLOWSHEETS

    Results Review,UCW_RESULTS_REVIEW

    Allergies/Contraindications,UCW_ALLERGIES

    History,UCW_HISTORY

    Problem List,UCW_PROBLEM_LIST

    Radiation Summary,RIS_RADIATION_TRACKING

    Breast Care Summary,RIS_MAMMO_PATIENT_STORY

];

='Dynamic no ending'&'<URL>EpicAct:' & [Token] & ',INFONAME:PATIENTID,INFOVALUE:' & pat_id

='Dynamic w/ending'&'<URL>EpicAct:' & [Token] & ',INFONAME:PATIENTID,INFOVALUE:' & pat_id &',InfoCvtID:EPT'

='Hard code no spaces'&'<URL>EpicAct:' & [Token] & ',INFONAME:PATIENTID,INFOVALUE:Z23,InfoCvtID:EPT'

='Hard coded with spaces'&'<URL>EpicAct:' & [Token] & ',INFONAME:PATIENTID,INFOVALUE:        Z3,InfoCvtID:EPT'

dclark0699
Creator
Creator

Hi Jeff,

Just to add on to your slides, for encounter specific things (at least the encounter summary and visit navigator) you can use two infonames

First:

INFONAME: PATIENTID

INFOVALUE: Padded EPT .1 (10 Characters)

Second

INFONAME: PATIENTDAT

INFOVALUE: DAT for the contact you are interested in

To get the DAT, you can take the constant 121531 and subtract the DTE for the encounter (pat_enc_date_real)

Simple SQL example:

select

enc.pat_enc_csn_id

,enc.pat_enc_date_real as dte

,121531-enc.pat_enc_date_real as dat

from pat_enc enc

where pat_enc_csn_id = :CSN

;

cspencer3
Creator II
Creator II

Can you speak to the security permissions that would need to be in place for the user to be able to use these links while in hyperspace. When we built a test app to use in our POC environment our team kept getting an Error: "The system has encountered a problem. You are not authorized to run this option." Are there a specific set of permissions that have to be granted to users in Epic to allow the Qlik integration?

joe_warbington
Partner - Creator III
Partner - Creator III

When you are in Hyperspace and click an activity link within a Qlik app, you'll need the appropriate Epic security to view that activity. For instance, if you click on a link that launches Chart Review for a patient, you'd need access to view patient charts in Epic.

Qlik won't give access to areas of Epic that users are not permitted to use.

cspencer3
Creator II
Creator II

I was using an old sample of code and it did not have the function to Pad the PAT_ID to 10 characters. That one fix was all we needed.

phcaptjim
Creator
Creator

Donnie, that is good information.

Can you post an example of how the expression would look for that encounter action?  Also, is it possible to open up an encounter using CSN instead of the DAT?  That would be easier for my current application.

dclark0699
Creator
Creator

Here is an example of the expression to get to the encounter summary report (at least in our Epic - 2014, not model system)

'EpicAct:MR_ENC_SUMMARY,INFONAME:PATIENTID,INFOVALUE:' & Repeat(' ',10-Len(PAT_ID)) & PAT_ID & ',INFONAME:PATIENTDAT,INFOVALUE:' & VISIT_DAT

I have not yet figured our a way to pass the CSN instead. I tried a long time ago with our CMIO, but once we found the DAT worked we haven't spent any more time on trying with the CSN since in our system I have ready access to both.

phcaptjim
Creator
Creator

Donnie, Thanks for the information!  I can't wait to implement this functionality.

qvd1rkqv
Creator
Creator

Not sure if it's because we're on 11.20 SR12 but this wouldn't work in an expression without the parentheses around the link text:

('Launch Chart Review')&'<URL>EpicAct:UCW_CHART_REVIEW,InfoName:PATIENTID,InfoValue:'& REPEAT(' ', (10 - LEN(PAT_ID))) & PAT_ID