1 2 3 4 Previous Next

Qlik Healthcare User Group

55 posts


I’m seeking help trying to create a Flag Field to catch add-on laboratory tests and have provided attached Excel workbook and QVW consisting of ER orders for a single day. 


By definition each ER patient is assigned a unique Accession number and 1 or more lab tests can be ordered. An add-on test is defined as any unique Accession with 2 or more tests where 1 or more of the tests has a Order Time Stamp 10 minutes greater than the “minimum” Order Time  Stamp.  By way of example in the image below the “Minimum” timestamp for this accession is 9:30 AM and the “DiffAuto” test was ordered 19 minutes after the original order so a the new “TestAddOn” flag field would be “True” or = 1.


The data set I am using is large so, optimizing the creation of this Test Add-on Flag withing the script is important.  Suggestions would be appreciated.




This blog post is related to the overall General Hospital project and will be used to post links to examples, tricks and training related to Data Modeling using the General Hospital data set.


Training Videos:

Dalton Ruer

General Hospital

Posted by Dalton Ruer Nov 13, 2017

General_Hospital_Qlik_Healthcare_Solutions_Logo_1.jpgHave you ever had to continually generate fake data sets that you could use to perform training with, do workshops with, do demo applications from or use as examples when learning new features/functions/visuals?


Well that's pretty much the life of the Qlik Healthcare Solution Architect team. So we decided to solve that problem for me and any others that may face the same issue.


We utilized a combination of data generated by Mockaroo as well as other data sources to form the base files of a fictitious health system we are calling General Hospital.


The goal of the project is to grow this to include many other resources that surround it like additional data sets, workshops, and applications.


How can you play along? Glad you asked.


Want to see a walkthrough video of everything and how this can be used? Watch this session on the Qlik General Hospital: Qlik Technical Thursday - November.


If you want to practice your Data Modeling skills you will want to download the base CSV files. Click here to get the base CSV data set:


If you want to have some example code that pulls the base CSV files and implements various data modeling techniques to see one approach we have prepared a QlikView and a Qlik Sense solution you can download:

Click here to get the QlikView application that will load the base CSV files and create Layer 2 versions of the tables.

Click here to get the Qlik Sense application that will load the base CSV files and create Layer 2 versions of the tables.


If you want to skip the data modeling step and jump right into visualizing by using the layer 2 data, we have prepared both a CSV and QVD version of the data for you:

Click here to get the Layer 2 CSV files.

Click here to get the Layer 2 QVD files.


But wait there's more! We have already built very basic load scripts for you to load the Layer 2 QVD data files in both QlikView and Qlik Sense if you want to start there:

Click here to get the QlikView application that will load the Layer 2 QVD files.

Click here to get the Qlik Sense application that will load the Layer 2 QVD files.


Just because we love you ... we have also created several image files that you can download to utilize for your own resources.

Click here to get the base General Hospital image

Click here to get the General Hospital Logo image

Click here to get an image of the General Hospital data model

NEW: On-demand recording of demo now available! View the Qlik Cerner SMART Analytics Adapter demo


As a Cerner client, you enjoy a data-rich, powerful, open EHR. What would you think if you could extend this robust system by embedding analytics directly within the clinician workflow?

Qlik Cerner SMART Analytics Adapter.png

Well, now you can. Qlik has developed the SMART Analytics Adapter – an API that lets you embed Qlik Sense Analytics dashboards right within Cerner Millennium. No toggling, no separate log in. Dashboards and apps incorporating more than just EMR data available within a patient chart.

So what does access to analytics within the EHR workflow do for clinicians?

  • Informs decision making, enabling improved outcomes.
  • Speeds decision making, having information seamlessly available.
  • Focuses decision making, efficiently using clinician time.

And this access does not compromise privacy or security. The SMART Analytics Adapter receives context from the user’s interaction within Millennium and allows the opening of dashboards, filtered by Millennium-defined authentication rights, to reflect the same patient set or details that were being viewed in the medical record.

This solution was featured at CHC in Kansas City the week of October 9th. We joined the Cerner Code Developer program and continue to work closely with Cerner to enhance and validate the SMART Analytics Adapter. This technology leverages the SMARTonFHIR and the Cerner Ignite APIs.

How do we get started or learn more:

If you didn't get a chance to visit with us at CHC and would like to learn more, please email Matt Stephens at Matt.Stephens@Qlik.com. Matt will share the technical requirements and use cases already deployed by joint Qlik/Cerner customers.

Additionally, join us for a live demo and Q&A on Nov 8th: Qlik Healthcare Demo Day - The SMART Analytics Adapter

We are pleased to have this solution validated by Cerner and featured prominently at CHC. Reach out today and get a conversation started on how your organization can offer embedded analytics to your clinical users.

Additional details attached available for Cerner clients in the private Qlik Cerner Group. Request access here: Cerner Developers Group

Qlik Cerner SMART Analytics Adapter screen.png

Integrating Qlik within Cerner allowed Children’s Hospital of Pittsburgh of UPMC to cut inefficiencies and standardize care processes.


Read more: http://global.qlik.com/us/blog/posts/mark-bilotta/customer-spotlight-24-hours-to-5-minutes-with-qlik



Do you use Cerner? Join our private Cerner Dev Group here to get access to documentation and learn about our new partnership: Cerner Developers Group.


Miss the recent news? We launched a new development with Cerner called the Qlik SMART Analytics Adapter, which allows you to embed Qlik in Cerner workflows using the SMARTonFHIR platform.

Hurricane season is unfortunately upon us. Just as Hurricane Harvey brought and continues to bring dangerous health concerns to people in Texas (see my previous post on Hurricane Harvey analytics), Hurricane Irma is threatening people and our health systems throughout Florida, Puerto Rico, and the region.

Rather than simply provide screenshots, I recorded the Qlik Sense + Qlik GeoAnalytics app in action and posted to YouTube so that you can see how quickly location intelligence and data visualizations can be used to help understand the impact and provide critical information. Over 56 million people are within the danger zones and that includes over 400 hospitals in Florida and Puerto Rico.

As always, be safe! If you think this type of analysis could help your hospital or communities, please reach out. We're happy to share everything.

-- Joe

Additional screenshots:

Here's the latest for Hurricane Harvey and hospitals that are within the danger zones. There are 752 hospitals that may be impacted or receive additional patient volumes depending on their location within the path of the storm.


2017-08-26 14_15_07-Hurricane season 2017-08-26 - Hospitals within danger zone _ Sheets - Qlik Sense.png


By choosing the >90% class of danger, we find 32 hospitals that are the most impacted. Most are in Corpus Christi, including our good friends at Driscoll Children's. We hope everything is safe and continues to be safe during the torrential rainfall.


2017-08-26 14_20_27-Hurricane season 2017-08-26 - Hurricane Harvey - Hospitals within danger zone (1.png


Here are the contact numbers in case you have loved ones that might be in those hospitals:


2017-08-26 14_20_09-Hurricane season 2017-08-26 - Hurricane Harvey - Hospitals within danger zone (1.png


Be safe! If you think this type of analysis could help your hospital or communities, please reach out. Happy to share everything.


Technically - this is using NOAA data for the hurricane path, hospital location data, and the capable functions within the new Qlik GeoAnalytics. !


Don't forget - if you're a CHIME member, you can get a great deal on Qlik Sense and Qlik GeoAnalytics until the end of September: https://chimecentral.org/qlik-healthcare/

Identifying patients with type 2 diabetes - a chronic, progressive condition that affects more than 29 million Americans and 415 million people globally - and those at risk for diabetes, is a first step in closing care gaps and improving the health of a population.


Do you have a 360-degree view of patients available at your fingertips, to help you meet quality metrics and improve care? You might think that’s information you’d find in your electronic health record (EHR) system. But we know there is more information about patients than just the data that gets stored in the EHR when they get sick or have an annual visit. These are called Social Determinants of Health (SDoH) and they include risk factors that might never be captured by clinicians – things such as credit score, access to quality food, and where you live or work in relation to your closest clinic or hospital...


My article is continued here with live demos and a video of the Qlik Healthcare Diabetes Discovery app: http://global.qlik.com/us/blog/posts/joe-warbington/discoveries-in-population-health . Please provide any feedback there. Thanks!


2017-06-22 13_21_12-Diabetes Discovery - Risks Analyzer _ Sheets - Qlik Sense.png


2017-06-22 13_17_03-Discoveries in Population Health _ Qlik.png

Here's a great little around the world tour of some of the integration points Qlik has with Cloudera - the leader in Hadoop datalakes.


Are you using Hadoop or comparable technologies in your healthcare organization? What are you using it for? We used it most recently for the Zika outbreak in collaboration with the University of Texas (link).


Technologies showcased include: Cloudera, Hadoop, Solr, Impala, Kafka, Kuda, Python/R, D3.js, Parquet, and SSO. Using Qlik APIs and Qlik Branch for visualizations.


(Click the YouTube button to view full screen)


Want to browse these demos on your own? Check out the Qlik Cloudera Integration and Demo Site: http://cloudera.qlik.com/



Prove that your healthcare organization has built an innovative app that has improved care, reduced costs, or increased population health.

Awarded after Qonnections (it was so packed, we didn't have time to review there)


Directions and Rules:

  • Please fill out the simple slide template attached, and include as much information as possible.
  • Must be a Qlik customer within healthcare.
  • You can submit as many entries as you’d like, though your organization can only win one prize.
  • Need not be present at Qonnections to win. Open to all customers!
  • Slides are due by Thursday May 25th.
  • Email slides (see attached template) to Joe.Warbington@qlik.com



Top 3 winners as decided after Qonnections will receive a free half-day workshop with our Healthcare Solutions Architects to empower your team on a topic/product of your choice. We’re happy to tune the engagement and schedule as desired.


Good luck!


Qlik Accelerate is a Qlik Consulting service that delivers pre-built applications designed and built by industry experts for real-life business scenarios. Once your data is loaded, the application can be ready to use and scaled to your business. Qlik Healthcare Accelerators are designed to help you accelerate time to value by enabling near real-time analytics of your operational, clinical and financial performance, so you can quickly react and make changes to improve health outcomes and net margin.


Our Healthcare Accelerators have been pre-built by a team of experts, and are based on best practices with other customers and industry-proven data models.  The applications are delivered with defined KPI’s and analytics, ready to accept your data from whatever EMR system you are running.  You can use the applications as is, or the Qlik Consulting Services team can further customize it, based on your own unique needs and requirements.


Recording (56 min)

Fast Track to Awesome Apps

Qlik Accelerate - Qlik Snippet


2016-09-21 17_44_54-Qlik Consulting_Qlik Accelerate_Healthcare.pptx - PowerPoint.jpg

2016-09-21 17_47_10-Qlik Consulting_Qlik Accelerate_Healthcare_Data Sheet.pdf - Adobe Acrobat Reader.jpg

Improving Healthcare with Analytics

The Essentials to Creating a Data-Driven Organization

Webinar Hosted by HIMSS

Thursday, September 8, 2016

2:00 PM ET/11:00 AM PT

2016-08-26 14_29_35-Improving Healthcare with Analytics_ The Essentials to Creating a Data-Driven Or.png


Countless healthcare systems and providers have embarked on a transformative journey with analytics. The ultimate aim is to foster an information-driven culture, where healthcare workers from nurses to executives make decisions based on timely, accurate information from any device in any location.


How do successful health systems transform their internal culture and processes to reflect the various demands of patients, stakeholders, and clinicians while also ensuring safety and profitability?


Join Qlik and John Martin, Sr. Director of Enterprise Analytics and Reporting at The Children's Hospital of Philadelphia, as they discuss the essential elements to create a data-driven organization and ensure value generation from analytics investments.


Topics covered will include:


  • Why providers are democratizing data to empower clinicians and staff
  • Tips to address the cultural shift towards data-driven decisions
  • How to unlock further value from your analytics investments


Featured Speakers

Joe Warbington
Healthcare Market Development Director

Charlotte Davies
Healthcare Consultant


John Martin
Director of Enterprise Analytics
The Children’s Hospital of Philadelphia

Learn more about our speakers


This webinar has been approved by HIMSS for up to 1 contact hour of continuing education credit toward renewal of the CPHIMS credential.

Register today to get a calendar invite and the recording, even if you can't make it.


2016-08-26 14_33_43-Social Image 1.jpg - Windows Photo Viewer.png

Customer Spotlight: Expanding the Toolbox | Qlik

Rochester Regional Health utilizes Qlik to make better use of their Epic data.


By Mark Bilotta on August 9, 2016

5 min read


Are you looking to get more out of your Epic data? We have just the thing for you: anon-demand webinar featuring a live demo by Qlik’s Joe Warbington and Eric Pennington, former Epic Cogito staff.


If you’ve been reading these Customer Spotlights in the past, you know the importance of fully understanding the patient journey. It’s well established that a more complete understanding of patient encounters, outcomes and costs and their interrelation leads to best practices. In turn, it allows each hospital or care facility to run more efficiently by reducing length of stay, avoiding preventable readmissions, and refining protocols for patients with chronic conditions.


Enter Rochester Regional Health...

Whose story rings true to many of these examples. As a newly formed health system, Rochester Regional Health (Rochester, NY) found itself using a variety of disparate systems -- Crystal Reports from Epic Systems and SQL-based extracts and reports that were dumped into Excel files – to extract and report data.  The health system’s director of Business Intelligence, David Meintel, knew that a single, integrated solution was required, a solution that was compatible with Epic.




Continued on the Qlik Blog here: Customer Spotlight: Expanding the Toolbox | Qlik

The Diabetes Management Qlik Sense Application guides you through a variety of clinically relevant factors in studying a population:

• KPIs tracking Triglyceride : HDL Cholesterol ratios, BMI, Microalbumin levels, etc,

• Diabetes patient visit statistics comparing them with patients across the population

• Comorbidity dashboard tracking patient population against 5 well known diabetes comorbidities

• Risk Analyzer that takes all patient visits in the sample set and allocates them into a collection of scatter charts so clinicians can slice/dice visits down to those exhibiting diabetes risk factors

• Diabetes Risk Score algorithm created within Sense that calculates a risk score for each patient based on their test results

• Lifestyle and Socioeconomic sheet tracking the non-clinical risk indicators of diabetes.


Recording (35 min)

Register for August 25, 2016 Demo

2016-08-09 18_29_30-Qlik Sense Desktop.jpg

2016-08-09 18_29_59-Qlik Sense Desktop.jpg

Many who make requests seem to have a belief that Business Intelligence is magic. They loose their ability to listen to logic and reason and simply ask you to do the impossible.


Pulling data from 18 different sources, many of which that you don’t even have access to. Childs play like pulling a rabbit from a hat.

Turning bad into good and interpreting the meaning of the data. A little tougher kind of like making your stunning assistant float in midair.

Creating a readmissions dashboard. Hey we aren’t Houdini.

That data doesn’t even really exist. Oh sure it exists in the minds of the people who want you to produce it out of thin air, but I’ve yet to see a single Electronic Health Record that stored readmission data. They only store admission data, not RE-admission data.

Patient NameAdmission DateDischarge Date
John Doe1/1/20161/4/2016
John Doe1/7/20161/10/2016
John Doe1/30/20162/4/2016

Those who want dashboards for Readmissions look at data like the above and talk to you like you are insane because in their minds it is clear as day that John Doe wasreadmitted on 1/7, 3 days after their first visit, and was then readmitted again on 1/30, 20 days after his second visit.

You can read the complete article at my QlikDork blog site and I will share how Qlik's ETL will help you do the "data magic" necessary to build a Readmission Dashboard.

Filter Blog

By date:
By tag: