A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights.
Hi All,
I hope you are doing well.
We started a QlikNprinting installation at a customer today.
They want us to install QlikNprinting in a local server (Workgroup) knowing that QlikSense (already installed) is not linked to the domain too.
Is it possible to link the connection between the two servers without being in the same domain? (just in the workgroup)?
Can you please help?
Thank you
Regards
The world's most popular English language proficiency test for higher education and global migration, accepted by over 10,000 organizations worldwide, can be your key to achieving your academic and professional goals.
We provide requisite assistance to those who, for one reason or another are unable to take the test or obtain the required band scores demanded by institutions, employers or embassy.
Contact us through the details below to know more about our services;
Telegram: Registraboard
I have a QlikSense dashboard that reflects data for individual physicians. Selecting their name displays their name at the top and all their corresponding performance metrics. I have each physician's headshot as a .jpg file and would like to have their headshot appear on the dashboard too. Has anyone done this?
Hello all,
I am not sure if this is a right forum but I wanted to get some inputs from Experienced business Intelligence Dashboard Developers on the development life cycle. So Please spare some minutes of your time and help me with filling this survey.
https://forms.gle/dTJQD1kfDRy3WQm5A
Greetings for the day!
I would really appreciate if you spend 3 minutes of your time today on answering my research survey.. Your response would greatly help me in my research analysis. Your responses would be summarized after grouping them and no individual identities would be revealed.
Thanks in advance!
Good Morning,
I am new to the group!
I am considering the potential of this tool to build an application for Capital Management and I am wondering how many organizations are using Qlik for that.
I would really appreciate hearing from anyone who has developed something or has considered the possibility. I am interested in hearing what is working, what isn't or even what made you decide that Qlik was not the best option if you thought about it and ended up going with a different solution.
Happy Friday!
Curious which healthcare organizations are leaking your health data (PHI)? Behold the HHS Wall of Shame.
Since the beginning of the year, there have been 292 breaches reported to HHS OCR. 35M+ people are affected from these breaches. Optum360 is responsible for the largest, with 11.5 million people affected.
HHS Wall of Shame app
If you want to try out this app, see attached QVF. You'll also need the Vizlib Library (free for up to 5 people): https://home.vizlib.com/vizlib-library-for-qlik-sense/
Does anyone have experience implementing healthy planet along with Org Filtering for Clairty and Caboodle? How did you manage the downstream impact to Qlik or other downstream solutions without having to migrate every solution one by one? Epic tells us Org filtering populates new schemas for clarity and caboodle, and many of our queries are fully qualified including the schema name.
We have a multi tier architecture in place, but we would still have to migrate every extract one by one...Hoping there's a better way.
Thanks!
I wrote a blog post for Qlik Branch (the Qlik Developer Community) on how to build your own wellness/activity tracker app using your personal health data from your Apple iPhone, Apple Watch, and various home monitoring devices. Enjoy!
FULL BLOG LINK with helpful images: https://branch-blog.qlik.com/apple-healthkit-a-delicious-qlik-recipe-d61167e7ab89
------------------------------------------
Apple continues to make health and fitness capability improvements to their software and devices. Every year at WWDC — their Worldwide Developers Conference — healthcare gets the spotlight for a moment. Building upon previous health announcements of the release of HealthKit (I wrote about this a few years ago: the Electronic Sickness Record), CareKit, ResearchKit, and Apple Health Records (recently I covered that: An Apple a Day Keeps the Doctor at Bay), they continue to make it easier for people to track their well-being, effortlessly.
Like the saying “the best camera you have is the one that’s with you”, IoT sensors passively collecting your health data will prove invaluable. In the past, this data had to be tracked manually, or through a visit to your doctor to assess occasionally. But it’s not that the data is being always collected and just there for you to review. It’s that it’s being collected seamlessly and combined with context to provide you and your care team with more complete and timely information that can be used to find things before it becomes a problem and you end up at the Emergency Department. This is the promise behind this technology in driving the way to true digital transformation in healthcare.
A little background and why I wanted to build an Apple HealthKit app
Your doctor and the systems they use (the EHRs — Electronic Health Records systems) only know so much about you. Think about it — your doctor usually only sees you once a year for your annual checkup, or when you are sick. The data your health system has therefore isn’t really a reflection of your health, but of your sickness at a few points in time.
Most likely there is a device in pocket that has much more detail about your health. Smart phones and fitness devices can provide you with a much better picture of your health overall, yet few doctors are utilizing this rich data.
My iPhone and Apple Watch are tracking key health measures in the background every minute. It’s recording my steps, blood pressure, weight, exercise, and nutrition. It knows my location, the temperature outside, and the air quality; these are all key factors or metrics important to my health. Unfortunately, the built-in health app is locked down and only shows snapshots of my health trends rather than more robust analysis of my personal health. Apple is making some changes here with iOS 13 and WatchOS 6, but you will be stuck with what they choose to display.
Using Qlik, I can analyze all of this collected data, in any way that I want. Using years of fitness data that is accurate down to the minute will tell stories of my health and activity. I can see how my diet is affecting my weight (did I really need that Grande size cappuccino and a chocolate croissant?), how I need to get better at walking 10,000 steps a day, how travel and weather impacts my exercise regimen (hint: travel means little to no exercise for me, and warmer weather at home means I get more steps in).
Does my doctor see any of this? Nope — not yet. Well, not unless I show her my phone — and then what will she do with data? Maybe we’d have a conversation about it while I’m sitting on the cold table in a funny gown, but she’s certainly not going to track how I’m doing next week or months later when I change my diet or visit the UW Memorial Union terrace for beers with friends more often during the summer.
While EHRs have the ability to bring in personal health data (often called PRO or Patient-Reported Outcomes), many organizations have not turned on this capability or they fail to use it effectively. This is a missed opportunity to see the whole story. Should we go ahead and just call the systems our doctors use Electronic Sickness Records?
How to download your personal health data for analysis
1. Export data from Apple Health app on iPhone. Click your Profile icon in the top-right corner, choose ‘Export Health Data’.
2. Save the ZIP file, load it onto your desktop, and extract the contents.
3. Pass the export.xml file through the Apple Health XML to CSV Converter: http://ericwolter.com/projects/health-export.html. This browser-based tool uses the FileReader API and FileSaver.js library to convert the file into CSVs, which are easier for us to use. Not comfortable with this step? Review the Github repository: https://github.com/eligrey/FileSaver.js
How to bake a nice Apple app with Qlik Sense
Once you’ve converted your Apple Health data into upwards of 40 different CSVs, you now have a fun problem on your hands. How do you bring all of this data together and get insights? I picked the most useful files based on file size and name, but you can grab anything and bring it into Qlik Sense and let the magic of the associative engine wire it all together. You will need to create a File Folder connection as likely some of the files are over the size limit for dragging-and-dropping into the interface.
The Associative Engine chooses the StartDate as the key field to bring everything together, and I renamed this to Date:
Another tool that I used to explore the data model was Catwalk — a great little utility from the Qlik Core team: https://catwalk.core.qlik.com
Catwalk provides a quick way to browse relationships and the data frequencies. I wouldn’t have quickly noticed which apps/devices were storing Apple Health data without it. For instance, I totally forgot that Pokémon Go was collecting and storing some health data for that brief time I wandered my neighborhood in search of creatures. I just use the javascript bookmarklet to quickly explore the data model for any open app as I’m developing. Give it a try!
Once you have the data loaded, you can start the visualization process and create stories about your own health. I used a healthy mix of native Qlik Sense objects and also some extensions from Vizlib and Narrative Science to paint these pictures.
I wanted to keep a familiar look and feel of the Apple Health and Apple Watch activity rings. A darkmode theme for Qlik Sense (build your own with Bitmetric’s SenseTheme Builder) and the Vizlib Activity Gauge object made it come together quickly and beautifully:
What better way to tell a story with your data, then by having your data tell the story directly?! Enter Narrative Science. I asked the extension to analyze my step count and give me some insights:
I didn’t want to stop there. Everybody has up and down days for activity. Did the data tell me anything about how my health is trending for the better (or the worse). I could infer some trends from the line charts, but a great way to measure warranted and unwarranted variation is with statistical control charts, such as this I-Chart from Acumen BI:
This highly configurable but easy-to-use extension helps you to quickly build a control chart. It’s not only showing the average steps, it is also automatically recalculating the average, upper control limit, lower control limit, and outliers based on runs and trend triggers. Looking at the chart above, I must have been on the road in late January as my steps dropped, causing my average to be recalculated lower. Net-net: I was walking less because I was tied up in meetings (and the weather probably wasn’t great either).
Last, and certainly not least, I wanted to figure out how to indicate one of the greatest moments of my life, the birth of my first child. You can clearly see a dip in activity (rightfully so) on the day Jack was born. How did I achieve this? With annotations on the Vizlib Line Chart object. It really helps tell the story of events and how they impacted the data. You’ll be happy to know that the baby and I go on numerous walks each week.
Telling the story of your health with data can be a truly personal and insightful experience. If you’ve been passively tracking your health with your devices, try throwing the data into Qlik to see what you can discover about yourself. Maybe it’ll even push you to get to those 10,000+ steps a day.
Now, get out there and close those rings!
Hi,
Am new to Qlikview . I have attended the training last week and trying to implement for the health domain.
Basically for each admission Id, we do have the admission date and Discharge date attributes. At times discharge attribute will be null( Empty) , for the Patients still in hospital.
So I want to include the records only with a valid discharge date and am trying to use the below expression to calculate the average length of stay ( i.e Dischargedate diff admission date ) but it does not work. Could you please help
Avg({$<Discharge_date={">=Date(01/01/2018)"}>}-admission_date).
Also, is there any null function check in qlikview?
backend code for tables load :
Load *,
Year(LoadDate) as admission_Year,
Month(LoadDate) as admission_Month,
Floor(LoadDate) as admission_date,
Floor(UnLoadDate) as Discharge_date;
LOAD ENCNTR_ID,
REG_DT_TM,
DISCH_DT_TM,
Date(Date#(REG_DT_TM,'DD/MM/YYYY')) as LoadDate,
Date(Date#(DISCH_DT_TM,'DD/MM/YYYY')) as UnLoadDate
We need to get live census data out of Epic's Chronicles (Cache) and into QlikView.
Has anyone tried to do this recently?
Here's a post from 2016 that describes doing it using Epic's Interconnect server using Epic's SOAP Web Service called GetCurrentCensus.
I'm looking for updated info about how to do this or confirmation of the applicability of that post from 3 years ago.
Any help will be very much appreciated!
Bonjour,
Nouvelle sur Qlik Sense j'essaye de répartir une somme en cumulée par mois dans un graphique mais rien ne fonctionne 😞
je m'explique j'ai une table avec un nom de programme et un montant mais pas de champ mois :
Target:
Load
Programme
Section
Number
Amount_Target
L'objectif est dans un graphique de faire le cumul par mois du Target exemple:
janvier : Amount_Target*1/12 ; fevrier : Amount_Target*2/12 , fevrier : Amount_Target*3/12 ....
Je suppose que je dois créer un champ mois et faire la répartition par la suite... mais je n'ai pas réussi
Est-ce-que vous avez la solution? j'espère que mes explications sont assez claires
Merci beaucoup 🙂
Sarah
Hi
I was trying to re-publish the same report with some changes in the page layout but with the same name to the application or report and scheduled time was set 6:00 am but scheduling was failed for these reports.
Our IT team expert is saying that re-published reports are wipes out the scheduled task for the previously published app.
Can somebody help me out to know the real reason for scheduling failure.
Data visualization helps to tell patient stories.
Check out this video ( https://youtu.be/CBnaPbGGWfc ) of various Qlik implementations for Healthcare including statistical process control charts (SPC), Vizlib dashboards, Apple HealthKit, and NHS Command Centers.
#Qlik #QlikSense #HealthTech #analytics #dataviz
In a set analysis how to excluded everthing but a table , for example :
I have a INSURED table , I want to apply an set analysis only to this
table ignoring to the others.
I want to count how many insured we have in a period for example but I won´t
to aplly to another column/dimensions.
Apply all filters setted to then table INSURED and not aplly to another.
Thank you.
Hi,
I am trying to use a color by expression but the legend does not appear, how can I use a color by expression and the legend to appear?
The code for color by expression was:
IF([Mujer con sífilis gestacional] = 1,RGB(255,124,125),
IF([Mujer con sífilis gestacional] = 2,RGB(169,208,142), RGB(255,230,153)))
Hi, I have been using qlikview for awhile now, but I am by no means an expert. I have a situation whereas when I add the encounter key I get the results I want when I remove it from the dimensions it does no longer work. Below I am trying to sum a count based on a charge qty within each encounter ID that the charges are > 0.
Variable Obscriteria holds my criteria for my type of patients = visit type, revenue line etc.. It does not exclude where charges are <=0, I could not get it to work in my script that way.
Below is my counter. Please let me know what I can do. I appreciate it.
if(sum({$<MonthYear=,
[Fiscal Year] = {$(vFYCurrent)},
[Discharge Date]={'<=$(vMaxDate)'},
$(vObsCriteria),
[Encounter ID]
>}
[Charge Quantity])
sum({$<
MonthYear=,
[Fiscal Year] = {$(vFYCurrent)},
[Discharge Date]={'<=$(vMaxDate)'},
$(vObsCriteria)
>}
EncounterCount),0)
We are in the process of getting our Qlik Sense deployment rolled out and I just ran into an issue today that I'm not sure how to solve.
We have 3 separate environments (Dev, TST and PRD). Now I have created a script to determine what environment you are in, be it dev, tst or prd. This allows us to use txt files that store ODBC connections and txt files for variables. So no matter what environment you are in Qlik Sense knows where to look for those files or where to store files. This works great in QlikView.
The issue I'm having now though is with Data Connections, specifically for ODBC connections. In dev we want our developers to use their own credentials for the ODBC connections, but in tst and prd we use Service Accounts. This is so our auditing group can differentiate who or what system is connecting to the databases. We don't want to use the developers credentials in tst and prd as they aren't actually connecting, but also we have to change our passwords every 90 days.
So the issue I'm running into is that I setup a data connection in all 3 environments. So we have data connection ODBC_QS_CLARITY. Now this also appends my user id to the name (very annoying WTH). So the actual name of the Data Connection is now ODBC_QS_CLARITY (jkofoot). So in tst and prd this is setup to use our service account, no issues. But if we want developers to use these ODBC connections but use their credentials, they have to edit the connection and when they do, their userid now gets appended to the data connection name. So now we would have a name like ODBC_QS_CLARITY (jkofoot) (asmith).
Also we want to store the connection string in a txt file which we reference by knowing what environment we are coming from. This worked awesome in QlikView because then each developer could hide their connection string as it included the username and password in the connection string. But now it is just a Lib statement that doesn't have the userid/password in it.
Basically just want to know how other groups are handling having developers use their own credentials for connecting to databases, but using service accounts for connecting to databases in tst or prd. Basically I'm not seeing a good way of doing it, without just resorting to using service account for everyone. Don't want to do that though as it has the potential to give more access to the developer than they should have.
Join Dalton Ruer and Joe Warbington on March 7th as they cover one of the newest innovations at Qlik: CrunchBot.
They'll explore how the AI-powered natural language Bot works within Healthcare and with common messaging platforms (like Slack, Microsoft Teams, Salesforce, Skype, etc.)
Qlik CrunchBot for Healthcare
This webinar will feature the latest addition to the Qlik Analytics Platform – CrunchBot, a conversational analytics tool that uses natural language processing and interfaces with popular collaboration tools such as Slack, Skype, Microsoft Teams, etc.
Learn how CrunchBot is being applied throughout healthcare organizations to improve data literacy and adoption. The webinar will also explore what chatting with your data can mean for achieving the Quadruple Aim.
#CrunchBot #NLG #NLP #AI #Chatbot
Corrected_Fact:
NOCONCATENATE
LOAD *
RESIDENT [Master Fact]
WHERE match(Corrected, 'Y');
DROP FIELDS [Posting Date] FROM Corrected_Fact;
LEFT JOIN(Corrected_Fact)
LOAD DISTINCT
[Corrected Date]
, [Corrected Date] AS [Posting Date]
RESIDENT Corrected_Fact;
DROP Fields [Corrected Date];
DROP Fields Corrected FROM [Master Fact];
// Unable to understand from here
LEFT JOIN ([Master Fact])
LOAD 'N' AS Corrected
Autogenerate 1;
CONCATENATE([Master Fact])
LOAD *
RESIDENT Corrected_Fact;
DROP TABLES Corrected_Fact;
I have this code in one of the apps. I am unable to understand the code entirely. It will be a great help if someone can explain to me what exactly the code is doing.
Thanks in advance.