THE FOREST OR JUST THE TREES& SET ANALYSIS IN QLIK - Prominence
THE FOREST OR JUST THE TREES& SET ANALYSIS IN QLIK11/20/2016
AnalyticsAnalytics TeamCultureData GovernanceDeploymentEpic ServicesEventsRevenue CycleWebinars All posts
Healthcare data can be tricky to deal with, and that’s one of the reasons we love what we do. We’ve solved hundreds of visualization challenges for healthcare organizations over the years, from helping them see disparate sources in a meaningful way to tailoring the user interface depending on the detail necessary for a given user.
Depending on the relationship between the data model and the user interface, there are many tricks we use to show exactly the information we’re seeking as part of a visualization. One of the ways we do this in QlikView and Qlik Sense is through Set Analysis.
What does Qlik’s Set Analysis functionality do?
Set Analysis is a syntax that lets us add our own logic in addition to (or in place of) user selections. Essentially, it lets us control the interpretation of parts of a whole.

Picture

Why does Set Analysis help with healthcare data scenarios?
In visualizing health data, we are often looking for ways to segment the whole. For example, we might have 3 years of admissions data loaded into our application, but we want to limit a specific chart to just the most recent 6 months, or to admissions coming from just from skilled nursing facilities, or to admissions with just the observation patient class. Sometimes, we want a chart to show a large set of data and then let the user filter based on a dimension (date, department, admission source, etc.). Through Set Analysis, not only can we control how the data loaded into the application is accessible within a chart, we can also define whether the logic should consider user selections. Depending on the scope of an application, presenting all the information and a bunch of filters and letting the users have at it won’t meet the consumption requirements. Effectively using Set Analysis lets us choose when to open the floodgates to the dataset in an application, while giving us chart-by-chart flexibility in how we show the subsets.
What does Qlik Set Analysis syntax look like?
The Set Analysis syntax looks like this:

Picture

Picture

It seems to get kind of complex, but when you break down the syntax relative to what you want to show, it starts to get easier. For example, if you want to know how many admissions there were in 2014, your Set Analysis looks like this:

Picture

Once you get comfortable with Set Analysis, there are lots of other fun ways to refine your results. You can use variables, use parameters, or change your assignment operators (see the overlapping circles image above). We consider Set Analysis a key tool in building healthcare-data user interfaces in QlikView and Qlik Sense, so we love trying to address new challenges through set analysis!
Recent Posts
Understand the basics of Data Governance technologies, including:  Why healthcare organizations choose to leverage Data Governance technologie…
Watch the University of Kentucky HealthCare’s Chris Burton as he discusses their approach to maximizing investments in multiple analytics tools, mini…
Streamlining your technology vendor list is a great way to improve data access, save money on software licensing, and maximize your team’s ability to…
Discover how Grady Health achieved a successful analytics tool transition from Qlik and Power BI to Tableau, along with automating data pipelines. Th…
Discover how Grady Health achieved a successful analytics tool transition from Qlik and Power BI to Tableau, along with automating data pipelines. Th…
© 2024 Prominence Advisors, Inc, All Rights Reserved

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Fermentum leo vel orci porta non pulvinar. Luctus venenatis lectus magna fringilla urna porttitor. Sodales ut eu sem integer vitae justo eget magna. Ultrices eros in cursus turpis massa tincidunt dui. Urna duis convallis convallis tellus id. Sed elementum tempus egestas sed sed risus pretium quam. Aliquam nulla facilisi cras fermentum odio eu feugiat pretium. Tellus in metus vulputate eu scelerisque. Sem nulla pharetra diam sit. Urna et pharetra pharetra massa massa ultricies mi quis hendrerit. Sed risus ultricies tristique nulla. Euismod lacinia at quis risus sed vulputate odio ut. Mauris rhoncus aenean vel elit. Tortor posuere ac ut consequat semper viverra nam libero. Pellentesque habitant morbi tristique senectus et netus et. Sem integer vitae justo eget magna fermentum iaculis eu non. Adipiscing diam donec adipiscing tristique. Massa sapien faucibus et molestie ac feugiat sed lectus vestibulum. Id diam vel quam elementum pulvinar.

Lorem ipsum dolor sit amet. Lobortis elementum nibh tellus molestie. Blandit volutpat maecenas volutpat blandit aliquam etiam erat velit scelerisque. Tellus cras adipiscing enim eu turpis egestas pretium aenean. Feugiat nisl pretium fusce id velit ut. Auctor urna nunc id cursus. Velit dignissim sodales ut eu sem integer vitae justo. Pellentesque adipiscing commodo elit at imperdiet dui accumsan sit. Nisi vitae suscipit tellus mauris. Interdum varius sit amet mattis vulputate enim. At risus viverra adipiscing at in tellus integer. Nunc scelerisque viverra mauris in aliquam sem. Convallis posuere morbi leo urna. In vitae turpis massa sed elementum tempus. Cursus euismod quis viverra nibh cras. Eros donec ac odio tempor orci dapibus ultrices in. Augue ut lectus arcu bibendum. Eget sit amet tellus cras adipiscing enim. Tincidunt praesent semper feugiat nibh sed pulvinar proin gravida.