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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
Gethyn
Creator
Creator

Hyperspace actions from QlikView

Hi Everyone,

I have created a few QlikView applications and integrated them into Hyperspace. I have got two Hyperspace actions working from the report, one in the way I want it to and the other in a workaround.

The one which works correctly links from the PAT_ID in the report and opens up the patient chart, this is set as an expression in a straight table with the display option set to link.

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

The one which I have a work around is to open up the medication order from the order ID. I haven't been able to get it to work as a link from an expression. What I had to do was set an Open URL action to a button with the following URL:

='EpicAct:AC_REVIEW_REPORT_VIEWER,RunParams:MR_REPORTS||6^  '&PAT_ID&'^'&ORDER_MED_ID&'^<6>'

I also set this enable condition to the button so that it only 'lights' up when the selection is limited to one ORDER_MED_ID

Count(Distinct(ORDER_MED_ID)) = 1

So now if I click on one of the ORDER_MED_IDs in my table the selection reduces to the lines with the same order and then I can go to the Medication order by pressing the button.

Does anybody know how I can make the second action work in the same way as the first? I would also be interested to know of any other actions which anyone has got to work from QlikView in hyperspace.

Thanks,

Gethyn.

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

Hi Gethyn,

See this post for some more examples (in the comments) of Epic activities that can be launched: Epic Integration Configuration.pdf

As for the Order launching button versus the link, we have to think about what data Qlik is returning - likely there are multiple patient IDs and multiple order IDs, though what you're getting is PAT_ID + a lot of Orders. What if you make your straight table contain PAT_ID and ORDER_MED_ID as dimensions? Each line in that table will then contain 1 and only 1 patient and order combination. Then the link should work.

Gethyn
Creator
Creator
Author

Hi Joe,

My straight table does contain the PAT_ID and the ORDER_MED_ID as dimensions, it just seems that the URL that I'm using to open the medication order report in Hyperspace doesn't work from an expression in the table. Is it something to do with the AC at the beginning of the action name? All the others that do work appear to start with UCW.

Thanks,

Gethyn.

joe_warbington
Partner - Creator III
Partner - Creator III

This would be a good one to take back to your Epic Cogito Systems TS or Orders TS to troubleshoot. The Epic activity may require a parameter that is different than you one you are providing... Please let us know what they say and how to resolve.