Qlik Community

Qlik Healthcare User Group

A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights.

CREATE A POST
Post a Question
  • Is it possible to link the connection between Qliksense and nprinting in workgro...

    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 (... Show More

    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

    Show Less
  • Get an official IELTS/TOEFL certificate(Whatsapp: +1 (513) 620—6443)

    The world's most popular English language proficiency test for higher education and global migration, accepted by over 10,000 organizations worldwide,... Show More

    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

    BC.jpg

     

    Show Less
  • Having images change with dimension selection

    I have a QlikSense dashboard that reflects data for individual physicians.  Selecting their name displays their name at the top and all their correspo... Show More

    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?

    Show Less
  • Understanding Business Intelligence Dashboard Development Lifecycle

    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 de... Show More

    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!

    Show Less
  • Is anyone using Qlik for Healthcare Capital Management?

    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... Show More

    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! 

     

    Show Less
  • HHS Wall of Shame - PHI data breaches

    Curious which healthcare organizations are leaking your health data (PHI)? Behold the HHS Wall of Shame. Since the beginning of the year, there have b... Show More

    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.

    [video]

    HHS Wall of Shame.pngHHS 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/

    Show Less
  • Epic Customers - Org Filtering and Clarity/Caboodle

    Does anyone have experience implementing healthy planet along with Org Filtering for Clairty and Caboodle? How did you manage the downstream impact to... Show More

    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!

    Show Less
  • Apple HealthKit - A Delicious Qlik Recipe

    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 d... Show More

    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

     
    AppleHealthKit Datamodel.png
     
     
    Show Less
  • Set analysis with Condition

    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 h... Show More

    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

    Show Less
  • views

    I would like to know who opens my shared app 😃
  • Live Census via Epic's Interconnect in QlikView

    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 d... Show More

    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.

    https://community.qlik.com/t5/Qlik-Epic-Developers/Getting-Live-Census-via-Interconnect-over-HTTPS-in-QV/gpm-p/1481549

    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!

     

    Show Less
  • Répartition montant en cumulé dans un graphique

    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... Show More

    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 

     

    Show Less
  • Published Report Scheduling Error when Publishing Report with same name

    HiI 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 ti... Show More

    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.

     

    Show Less
  • Data Visualization Highlights for Healthcare - Video

    Data visualization helps to tell patient stories. Check out this video ( https://youtu.be/CBnaPbGGWfc ) of various Qlik implementations for Healthcare... Show More

    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.

    [video]

     

    Healthcare 1 (1).pngHealthcare 1 (2).pngHealthcare 1 (3).pngHealthcare 1 (4).png

    #Qlik #QlikSense #HealthTech #analytics #dataviz

    @vizlibmartin @danielgargiulo 

    Show Less
  • Set Analysis , excluding a table

    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 thistable igno... Show More

    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.

    Show Less
  • how to put a legend when colors by expression?

    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... Show More

    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)))

     

    Show Less
  • Count encounters whereas the sum of charges >0

    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 resul... Show More

    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)

    Show Less
  • How are you using QS Data Connections when using user accounts and service accou...

    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 sepa... Show More

    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.

    Show Less
  • Qlik CrunchBot for Healthcare - Webinar March 7th

    https://lnkd.in/euPnKN5 Join Dalton Ruer and Joe Warbington on March 7th as they cover one of the newest innovations at Qlik: CrunchBot. They'll expl... Show More

    https://lnkd.in/euPnKN5

    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.)

     

    CrunchBot webinar.pngQlik 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

    Show Less
  • Unable to understand the following code

    Corrected_Fact:NOCONCATENATELOAD *RESIDENT [Master Fact]WHERE match(Corrected, 'Y');DROP FIELDS [Posting Date] FROM Corrected_Fact;LEFT JOIN(Corrected... Show More

    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.

    Show Less
Group details
Qlik Healthcare User Group
Qlik Healthcare User Group
811 members Open Group Since ‎2018-11-11 08:20 AM
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights.
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights.
Group Admin
joe_warbington Partner
Dalton_Ruer Employee
Members (811)