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
  • Sepsis Dashboard

    Hi all,it has been a while I blogged about my favorite BI took, QlikView. I worked on a very cool project back in 2016 and finally blogged about it. H... Show More

    Hi all,

    it has been a while I blogged about my favorite BI took, QlikView. I worked on a very cool project back in 2016 and finally blogged about it. Hope you will enjoy.

    A silent killer

    Sepsis is the body’s extreme response to an infection. It is a life-threatening medical emergency. Sepsis happens when an infection you already have —in your skin, lungs, urinary tract, or somewhere else—triggers a chain reaction throughout your body. Without timely treatment, sepsis can rapidly lead to tissue damage, organ failure, and death. 1

    More than 1.5 million people get sepsis each year in the U.S. At least 250,000 Americans die from sepsis each year 2. Sepsis kills more people than breast cancer, prostate cancer, and AIDS...Combined3.

    Yet, not many people know about it. We've all heard so much about Ebola and H1N1, but not many of us have heard about Sepsis. Who is at risk to get Ebola or H1N1? A few...Who is at risk to get Sepsis? We are all! Sepsis does not discriminate. It kills the young or the old, the rich or the poor, and it kills quickly.

    https://boristyukin.com/sepsis-dashboard/

    Show Less
  • Trying to use intervalmatch with join

    Hi,Could anyone help please,I want to make table join with a key and range of dates, but i don't know why it is duplicated the register. [La_33]:... Show More

    Hi,

    Could anyone help please,

    I want to make table join with a key and range of dates, but i don't know why it is duplicated the register.

     

    [La_33]:
    LOAD
    NIT_IPS&'-'&COD_SERVICIO&'-'&TIPO_CONTRATO AS LLAVE1,
    NIT_IPS&'-'&COD_SERVICIO&'-'&TIPO_CONTRATO AS LLAVE2,
    NUM_FACTURA,
    NUM_RADICA,
    ESTADO_RADICA,
    ITEM,
    TIPO_DOC,
    DOC_AFILIADO,
    TIPO_DOC&'-'&DOC_AFILIADO AS DOCUMENTO,
    COD_SEXO,
    EDAD,
    DIAGNOSTICO,
    DESCR_DIAGNOSTICO,
    DIA_RADICACION,
    MES_RADICACION,
    ANIO_RADICACION,
    DIA_RADICACION&'/'&MES_RADICACION&'/'&ANIO_RADICACION as Fecha_Radicacion,
    DIA_CONTABLE,
    MES_CONTABLE,
    ANIO_CONTABLE,
    DIA_CONTABLE&'/'&MES_CONTABLE&'/'&ANIO_CONTABLE as Fecha_Contable,
    DIA_PRESTACION,
    MES_PRESTACION,
    ANIO_PRESTACION,
    // ANIO_PRESTACION as PERIODO_TARIFA,
    DIA_PRESTACION&'/'&MES_PRESTACION&'/'&ANIO_PRESTACION as Fecha_Prestacion,
    CCONTABLE,
    DESC_CONCEPTO_CONTABLE,
    VALOR_COBRADOIPS,
    VALOR_APAGAR,
    CANTIDAD,
    VALOR_APAGAR/CANTIDAD as VALOR_UNITARIO,
    RAZON_SOCIAL,
    NIT_IPS AS NIT_IPS_INTEGRACION,
    MUNICIPIO_AFI,
    if(MUNICIPIO_AFI = 'MEDELLIN','MEDELLIN','RESTO') as Dist.Mun.AFI,
    DEPARTAMENTO_AFI,
    REGION_AFI,
    MUNICIPIO_IPS,
    if(MUNICIPIO_IPS='MEDELLIN','MEDELLIN','RESTO') as Dist.Mun.IPS,
    DEPARTAMENTO_IPS,
    REGION_IPS,
    COD_SERVICIO AS C_SERVICIO,
    if(index(COD_SERVICIO, '-', 1) > 0,
    left(COD_SERVICIO,
    index(COD_SERVICIO, '-', 1) - 1), COD_SERVICIO) as COD_SERVICIO_SIN_GUION,
    COD_GRUPO,
    COD_SUBGRUPO,
    DESCR_SERVICIO,
    COD_PATOLOGIA,
    DESC_PATOLOGIA,
    TIPO_CONTRATO AS TIPO_CONTRATO_33
    // , TRIM(TIPO_CONTRATO) AS TIPO_CONTRATO_ANTIGUO,
    // COD_SERVICIO as COD_SERVICIO_CONTRATO_ANTIGUO,
    // NIT_IPS AS NIT_IPS_CONTRATO_ANTIGUO
    FROM [lib://qvdsalud (integrasavia_svcqlik)/Contabilizacion_Contable.qvd]
    (qvd);

    NoConcatenate

    [La_33_integracions]:
    Load
    LLAVE1,
    LLAVE2,
    NUM_FACTURA,
    NUM_RADICA,
    ESTADO_RADICA,
    ITEM,
    TIPO_DOC,
    DOC_AFILIADO,
    DOCUMENTO,
    COD_SEXO,
    EDAD,
    DIAGNOSTICO,
    DESCR_DIAGNOSTICO,
    DIA_RADICACION,
    MES_RADICACION,
    ANIO_RADICACION,
    DIA_CONTABLE,
    MES_CONTABLE,
    ANIO_CONTABLE,
    DIA_PRESTACION,
    MES_PRESTACION,
    ANIO_PRESTACION,
    CCONTABLE,
    DESC_CONCEPTO_CONTABLE,
    VALOR_COBRADOIPS,
    VALOR_APAGAR,
    CANTIDAD,
    VALOR_APAGAR/CANTIDAD as VALOR_UNITARIO,
    RAZON_SOCIAL,
    NIT_IPS_INTEGRACION,
    MUNICIPIO_AFI,
    DATE(Date#(Fecha_Prestacion,'DD/MM/YYYY')) AS Fecha_Prestacion,
    DATE(Date#(Fecha_Radicacion,'DD/MM/YYYY')) AS Fecha_Radicacion,
    DATE(Date#(Fecha_Contable,'DD/MM/YYYY')) AS Fecha_Contable,
    Dist.Mun.AFI,
    DEPARTAMENTO_AFI,
    REGION_AFI,
    MUNICIPIO_IPS,
    Dist.Mun.IPS,
    DEPARTAMENTO_IPS,
    REGION_IPS,
    C_SERVICIO,
    COD_SERVICIO_SIN_GUION,
    COD_GRUPO,
    COD_SUBGRUPO,
    DESCR_SERVICIO,
    COD_PATOLOGIA,
    DESC_PATOLOGIA,
    TIPO_CONTRATO_33
    Resident La_33
    Where ANIO_PRESTACION>2017 and (NIT_IPS_INTEGRACION='900625317' or NIT_IPS_INTEGRACION='890904646' or NIT_IPS_INTEGRACION='800058016');
    Drop Table La_33;

    CONTRATOS:
    LOAD
    NIT_IPS&'-'&COD_SERVICIO&'-'&IF(MODELO_CONTRATA='EVENTO','E','OTROS') AS LLAVE1,
    COD_SERVICIO,
    COD_SUBGRUPO as SUBGRUPO,
    COD_GRUPO AS GRUPO,
    DESCR_SERVICIO AS DESC_SERVICIO,
    ESTADO_CONTRATO,
    CONTRATO_ENTIDAD,
    CONTRATO_LEGAL,
    NIVEL_COMPLEJIDAD,
    MODELO_CONTRATA,
    IF(trim(MODELO_CONTRATA)='EVENTO','E','OTROS') AS TIPO_CONTRATO,
    DATE(Date#(FECHAINICIO,'DD/MM/YYYY')) AS FECHAINICIO,
    DATE(Date#(FECHAFINAL,'DD/MM/YYYY')) AS FECHAFINAL,
    AddMonths(DATE(Date#(FECHAINICIO,'DD/MM/YYYY')),-1) AS FECHAINICIO_ANTERIOR,
    PERIODO_TARIFA,
    VALOR_CONTRATO,
    COSTO_MAYOR,
    COSTO_MENOR,
    PVP,
    PORC_VAR,
    INCLUYE,
    MANUAL_TARIFARIO,
    VALOR_FINAL_SERVICIO,
    TIPO_DE_CONTRATO,
    NIT_IPS ,
    RAZON_SOCIAL AS RAZON_SOCIAL_CONTRATOS,
    NOMBRE_SEDE
    FROM [lib://qvdsalud (integrasavia_svcqlik)/Contratos.Qvd]
    (qvd);

    Left Join (La_33_integracions)

    IntervalMatch(Fecha_Prestacion,LLAVE1)

    LOAD FECHAINICIO,

    FECHAFINAL,

    LLAVE1

    Resident CONTRATOS;

    Left Join (La_33_integracions)

    LOAD *

    Resident CONTRATOS;

    DROP Table CONTRATOS;

    CONTRATOS_antiguos:
    LOAD
    NIT_IPS&'-'&COD_SERVICIO&'-'&IF(MODELO_CONTRATA='EVENTO','E','OTROS') AS LLAVE2,
    COD_SERVICIO as COD_SERVICIO_CONTRATO_ANTIGUO,
    CONTRATO_LEGAL as CONTRATO_LEGAL_ANTIGUO,
    IF(trim(MODELO_CONTRATA)='EVENTO','E','OTROS') AS TIPO_CONTRATO_ANTIGUO,
    DATE(Date#(FECHAINICIO,'DD/MM/YYYY')) AS FECHAINICIO_CONTRATO_ANTIGUO,
    DATE(Date#(FECHAFINAL,'DD/MM/YYYY')) AS FECHAFINAL_CONTRATO_ANTIGUO,
    MANUAL_TARIFARIO AS MANUAL_TARIFARIO_CONTRATO_ANTIGUO,
    VALOR_FINAL_SERVICIO AS VALOR_FINAL_SERVICIO_CONTRATO_ANTIGUO,

    NIT_IPS AS NIT_IPS_CONTRATO_ANTIGUO

    FROM [lib://qvdsalud (integrasavia_svcqlik)/Contratos.Qvd]
    (qvd);

     

    Left Join (La_33_integracions)

    NIT_IPS_CONTRATO_ANTIGUO,COD_SERVICIO_CONTRATO_ANTIGUO,TIPO_CONTRATO_ANTIGUO)
    IntervalMatch(FECHAINICIO_ANTERIOR,LLAVE2)

    LOAD FECHAINICIO_CONTRATO_ANTIGUO,

    FECHAFINAL_CONTRATO_ANTIGUO,

    LLAVE2
    Resident CONTRATOS_antiguos;

     

    Left Join (La_33_integracions)

    LOAD *

    Resident CONTRATOS_antiguos;

    DROP Table CONTRATOS_antiguos;

    Show Less
  • New member.... Pharmacy and EHR development

    Hello group...I am new to QLIK,  within EHR development, primarily pharmacy services.....and want to explore some general reports, dashboards, sc... Show More

    Hello group...

    I am new to QLIK,  within EHR development, primarily pharmacy services.....and want to explore some general reports, dashboards, scoreboards etc. that folks have used to get a general feel.

    I see some pharmacy-specific discussions going on, and would like to see a few posters, ppt, or something that has  been developed within QLIK.

    thank you
    Jay Goodman R.Ph

    DSS Inc.

    jgoodman@dssinc.com

    Show Less
  • SHarepoint Connection to Qliksense

    https://community.qlik.com/t5/Qlik-Healthcare-User-Group/How-to-Connect-QlikSense-to-a-2013-SharePoint-List/gpm-p/1478741In reference to the above. I ... Show More

    https://community.qlik.com/t5/Qlik-Healthcare-User-Group/How-to-Connect-QlikSense-to-a-2013-SharePoint-List/gpm-p/1478741

    In reference to the above. I get the following in my connection but no data shows up. Can someone please help ?

    Problem.PNG

    Show Less
  • We need your help!

    We in Product Design Group at Qlik need your help! We are embarking on a study in which we want to update our understanding of the real user needs so ... Show More

    We in Product Design Group at Qlik need your help! We are embarking on a study in which we want to update our understanding of the real user needs so that we are better equipped to focus our resources on areas where improvements are most needed.

    Our first step is a survey with the purpose of identifying where the biggest struggles and delights are for people who need to get different kinds of jobs done with Qlik Sense and other data analytics solutions. The survey takes about 5-7 minutes to complete.

    Here is the link to the survey:

    https://forms.office.com/Pages/ResponsePage.aspx?id=X-sewqb16ESplxJPL3pJfFrGb8WQnz9Mo2pO-2HRI9NUOE1B...

    Thank you for your support!

    Show Less
  • Need to Calculate Previous Year Charge Amount

    I need to calculate the charge amount for the previous year. I am using the following formula but it's not working. Can somebody help me out?Sum({<... Show More

    I need to calculate the charge amount for the previous year. I am using the following formula but it's not working. Can somebody help me out?

    Sum({<Corrected ={'N'}, year(posting date)= {$(=year(posting date) - 1)}>} Amount)
    -
    Sum({<Corrected ={'Y'},year(posting date)= {$(=year(posting date) - 1)}>} [Amount])

    Show Less
  • I get an error when grouping a table by group by in script

    Hi good day,I'm trying to group a table and I get Invalid expression, how can I solve this problem. This is my script:CONTRATOS:LOADNIT_IPS&'-'&am... Show More

    Hi good day,

    I'm trying to group a table and I get Invalid expression, how can I solve this problem. This is my script:

    CONTRATOS:
    LOAD
    NIT_IPS&'-'&COD_SERVICIO&'-'&IF(MODELO_CONTRATA='EVENTO','E','OTROS') AS LLAVE1,
    COD_SERVICIO,
    COD_SUBGRUPO as SUBGRUPO,
    COD_GRUPO AS GRUPO,
    DESCR_SERVICIO AS DESC_SERVICIO,
    ESTADO_CONTRATO,
    CONTRATO_ENTIDAD,
    CONTRATO_LEGAL,
    NIVEL_COMPLEJIDAD,
    MODELO_CONTRATA,
    IF(trim(MODELO_CONTRATA)='EVENTO','E','OTROS') AS TIPO_CONTRATO,
    DATE(Date#(min(FECHAINICIO),'DD/MM/YYYY')) AS FECHAINICIO,
    DATE(Date#(max(FECHAFINAL),'DD/MM/YYYY')) AS FECHAFINAL,
    // AddMonths(DATE(Date#(FECHAINICIO,'DD/MM/YYYY')),-1) AS FECHAINICIO_ANTERIOR,
    PERIODO_TARIFA,
    max(VALOR_CONTRATO) as VALOR_CONTRATO,
    COSTO_MAYOR,
    COSTO_MENOR,
    PVP,
    PORC_VAR,
    INCLUYE,
    MANUAL_TARIFARIO,
    max(VALOR_FINAL_SERVICIO) as VALOR_FINAL_SERVICIO,
    TIPO_DE_CONTRATO,
    NIT_IPS ,
    RAZON_SOCIAL ,
    NOMBRE_SEDE
    FROM [lib://qvdsalud (integrasavia_svcqlik)/Contratos.Qvd]
    (qvd)
    Group by CONTRATO_LEGAL,NIT_IPS,COD_SERVICIO;

    Show Less
  • Limitar la selección

    Buenos días:Estoy trabajando en una hoja Qlik en donde quiero que el usuario solo pueda seleccionar un valor del campo principal de selecció... Show More

    Buenos días:

    Estoy trabajando en una hoja Qlik en donde quiero que el usuario solo pueda seleccionar un valor del campo principal de selección y un solo valor para el campo fecha.

    Por ejemplo el campo principal "Centro" lo componen los distintos centros de la planta: C1, C2, C3, .......

    Quiero que la hoja muestre los valores de productividad para un solo centro y un solo dia en función de la selección del usuario. Es decir el usuario debe seleccionar Centro y fecha antes de mostrar los datps en la hoja. No quiero que el usuario pueda seleccionar masde un centro o mas de una fecha

    ¿Como se puede hacer?

    Muchas gracias por adelantado

    Show Less
  • How to remove the text qualifier

    Hi good day,I am loading a file that comes with a text qualifier in "and I want to be able to remove that character for the correct reading of the var... Show More

    Hi good day,

    I am loading a file that comes with a text qualifier in "and I want to be able to remove that character for the correct reading of the variables, which command I should use from the load to be able to remove that character.

    autorizacionesanual:

    LOAD

              *

    FROM [lib://fuente_salud (integrasavia_svcqlik)/reporte_prueba.csv]

    (txt, codepage is 28591, embedded labels, delimiter is ',', no quotes, no eof);

    Show Less
  • Translate a sentence in SQL for Qlik

    Hi, I am trying to translate one sentences in SQL for to do in Qlik, this is my sentence:SELECT *, ROW_NUMBER() OVER(PARTITION BY SalesOrderNumber ORD... Show More

    Hi,

    I am trying to translate one sentences in SQL for to do in Qlik, this is my sentence:

    SELECT *, ROW_NUMBER() OVER(PARTITION BY SalesOrderNumber ORDER BY ProductID) AS NumeroFila FROM Ventas

    This is about making a cumulative account that starts at 1 and when you find the next record equal to 2 and so on

    Show Less
  • how to use peek instead of previous or below

    Good day,I am trying to compare one date against another when DocAfiliado and PROGRAM are the same with this sentence:if (DocAffiliated = Previous (Do... Show More

    Good day,

    I am trying to compare one date against another when DocAfiliado and PROGRAM are the same with this sentence:

    if (DocAffiliated = Previous (DocAffiliated) and PROGRAM = Previous (PROGRAM), if (InMonth (Restorationdate, Previous (Restorationdate), 8), 'Out of range 8 months',' Within the 8 month range '),' Different document ') as Rank 8 months

    But I want to be able to compare since they belong to the same DocAffiliate and PROGRAM to be able to compare the records by date against the first record or NumberFile = 1, I am trying to do so:

    if (DocAffiliated = Previous (DocAffiliated) and PROGRAM = Previous (PROGRAM), if (InMonth (Restorationdate, Peek (Restorationdate, 0, 'Restorationdate'), 8), 'Outside the 8-month interval', 'Within the 8-month interval '),' Different document ') as Rank8 months

    2018-10-30.png

    if someone give me a light i goint to be so much greatfull

    Show Less
  • Select the 1% of the most expensive population

    Hi,I try to select the 1% of the most expensive population, I have made a graph of indicators that show how much the percentage of the cost consumes a... Show More

    Hi,

    I try to select the 1% of the most expensive population, I have made a graph of indicators that show how much the percentage of the cost consumes and a pareto table that accumulates the consumption of patients from higher to lower but I have tried to create a dimension that I classify these accumulated percentages of the pareto table by percentiles to filter.
    If someone gives me a light I will be very grateful

    Show Less
  • how can I create a dimension in which I choose the pacients by percentile?

    Hi,Im trying to make a dimension that identify the percentile that i want for later make a filter. i just rank my patient but i could not identify his... Show More

    Hi,

    Im trying to make a dimension that identify the percentile that i want for later make a filter. i just rank my patient but i could not identify his percentile.

    rank(Aggr(sum([Autorizaciones.COSTO_SERVICIO]), [CONTRATO_AFIL]))

    this sentences doesnt work just put 0.5%:

    if(rank(Aggr(sum([Autorizaciones.COSTO_SERVICIO]), [CONTRATO_AFIL]))*.0105<rank(Aggr(sum([Autorizaciones.COSTO_SERVICIO]), [CONTRATO_AFIL])),'0.5%','otros')

    Thanks

    Show Less
  • Qlik Sense - Epic Dashboard Component

    Hi all,This is my first post.I am trying to create a hyperlink to open patient charts from QlikSense to Epic Hyperspace similar to QlikView.  Thi... Show More

    Hi all,

    This is my first post.

    I am trying to create a hyperlink to open patient charts from QlikSense to Epic Hyperspace similar to QlikView.  This is all in an epic dashboard.  Below is what I used in QlikView, but it does not work correctly for QlikSense. 

    Any help would be appreciated.  Thank you.

    if(

    concat(PatientID) and concat(Surgical CSN),'Chart Review<url>EpicAct:UCW_CHART_REVIEW,INFONAME:PATIENTID,INFOVALUE:' & Repeat('%20', 10 - Len(PatientID) & only(PatientID]) & ',INFONAME:PATIENTCONTACT,INFOVALUE:' & only(Surgical CSN)

    ,

    null()

    )

    Show Less
  • I want to select the one porcent of the population more expensive

    Hi,Im trying to select the one porcent of the population more expensive,  I have done a indicator chart that shows how much the one porcent consu... Show More

    Hi,

    Im trying to select the one porcent of the population more expensive,  I have done a indicator chart that shows how much the one porcent consume of the cost. The sentence of the indicator chart is this:

    Sum({<[CONTRATO_AFIL] = {"=rank(sum([Autorizaciones.COSTO_SERVICIO]), 0) <= (rank(count(distinct([CONTRATO_AFIL])), 0)*.02)"}>} [Autorizaciones.COSTO_SERVICIO])/sum(total([Autorizaciones.COSTO_SERVICIO]))

    If can someone give me a light im going to be so grateful

    Show Less
  • Incremental load for date

    Hi good day,I am trying to create an incremental load of my records, and from my historical data use the last modification date to upload only those n... Show More

    Hi good day,


    I am trying to create an incremental load of my records, and from my historical data use the last modification date to upload only those new or updated files that have been modified in the file with the new and updated records. In the excel file sheet 1 brings the historical and in sheet 2 the new and modified files, but in sheet 2 I included a file with a date after the historical one to verify that it will not be updated and the most current record will remain .

    Thank you very much if you give me a light.

    T1:

    LOAD

        *

    FROM [lib://CARGA_INCREMENTAL/incremental.Qvd](qvd);

    sub:

    LOAD Date(max(FECHA_SOLICITUD)) as maxID

    Resident T1;

    DROP Table T1;

    let vmaxID=Peek('maxID',-1,T1);

    Incremental:

    LOAD

        *

    FROM

    [lib://CARGA_INCREMENTAL/incremental.Qvd](qvd);

    Concatenate

    LOAD

         *

    FROM

    [lib://CARGA_INCREMENTAL/direfencial.Qvd](qvd)

    Where FECHA_SOLICITUD>$(vmaxID);

    STORE Incremental into [lib://CARGA_INCREMENTAL/Prueba4_Incremental.qvd](qvd);

    Show Less
  • i need a help

    Hi good day, I am trying to filter a table by means of a date taken from another table but it is not filtering me. What is my mistake?T1:LOAD &nb... Show More

    Hi good day,

    I am trying to filter a table by means of a date taken from another table but it is not filtering me. What is my mistake?

    T1:

    LOAD

        ID_RECIBIDO,

        TIPO_ORIGEN_ANEXO,

        DATE(FECHA_SOLICITUD) AS FECHA_SOLICITUD,

        HORA_SOLICITUD,

        Date(Date#(FECHA_HORA_SOLICITUD,'DD/MM/YYYY:h:mm:ss')) as FECHA_HORA_SOLICITUD,

        DATE(FECHA_REGULACION) AS FECHA_REGULACION,

        HORA_REGULACION,

        CIUDAD,

        AFILIADO_NOMBRES_APELLIDOS,

        Identificacion,

        Estado,

        ESTADO_EVENTOS,

        IPS_remitio,

        IPS_asigna,

        IPS_ACEPTA,

        COD_IPS_REMITE,

        COD_IPS_ASIGNA,

        COD_IPS_ACEPTA,

        Nua_autorizacion,

        DATE(FECHA_AUTORIZACION) AS FECHA_AUTORIZACION,

        HORA_AUTORIZACION,

        FECHA_UBICACION,

        HORA_UBICACION,

        DESC_CONCEPTO_CONTABLE,

        cod_servicio,

        DESCRIPCION_SERVICIO,

        Observaciones,

        DESCRIP_AMBITO,

        ESPECIALIDAD,

        Diagnostico_Principal

    FROM [lib://CARGA_INCREMENTAL/incremental.Qvd](qvd);

    sub:

    LOAD Date(max(FECHA_SOLICITUD)) as maxID

    Resident T1;

    DROP Table T1;

    let vmaxID=Peek('maxID',-1,T1);

    Nuevos:

    LOAD

          ID_RECIBIDO,

        TIPO_ORIGEN_ANEXO,

        DATE(FECHA_SOLICITUD) AS FECHA_SOLICITUD,

        HORA_SOLICITUD,

        Date(Date#(FECHA_HORA_SOLICITUD,'DD/MM/YYYY:h:mm:ss')) as FECHA_HORA_SOLICITUD,

        DATE(FECHA_REGULACION) AS FECHA_REGULACION,

        HORA_REGULACION,

        CIUDAD,

        AFILIADO_NOMBRES_APELLIDOS,

        Identificacion,

        Estado,

        ESTADO_EVENTOS,

        IPS_remitio,

        IPS_asigna,

        IPS_ACEPTA,

        COD_IPS_REMITE,

        COD_IPS_ASIGNA,

        COD_IPS_ACEPTA,

        Nua_autorizacion,

        DATE(FECHA_AUTORIZACION) AS FECHA_AUTORIZACION,

        HORA_AUTORIZACION,

        FECHA_UBICACION,

        HORA_UBICACION,

        DESC_CONCEPTO_CONTABLE,

        cod_servicio,

        DESCRIPCION_SERVICIO,

        Observaciones,

        DESCRIP_AMBITO,

        ESPECIALIDAD,

        Diagnostico_Principal

    FROM

    [lib://CARGA_INCREMENTAL/direfencial.Qvd](qvd)

    Where FECHA_SOLICITUD>$(vmaxID);

    Show Less
  • How can i use where in the load?

    Hi,Im trying to filter since load with the argument when for just load the lines with 'VIGENTE', but i dont know how use it. This is my sentence:Tabla... Show More

    Hi,

    Im trying to filter since load with the argument when for just load the lines with 'VIGENTE', but i dont know how use it. This is my sentence:

    TablaUnidistintos:

    LOAD *,

    if("Num CCOBRO"=Previous("Num CCOBRO"),if(ESTADO<Previous(ESTADO),'VIGENTE','NO VIGENTE'),'VIGENTE') as VIGENTE

    Resident tablaUnifOrdenada

    Where VIGENTE='VIGENTE';

    Thanks if you give me a light

    Show Less
  • Nested Condicions

    Hi,Im trying to use a nested if but i dont know which is my mistake, this is my sentences:if(PROGRAMA={'Aplicación de flúor tópico'} or PROGRAMA={'Apl... Show More

    Hi,

    Im trying to use a nested if but i dont know which is my mistake, this is my sentences:

    if(PROGRAMA={'Aplicación de flúor tópico'} or PROGRAMA={'Aplicación de sellantes'}, IF(NumeroFila < 3,'Cumple','No Cumple'),'OTRAS')


    thanks if you give a light

    Show Less
  • Master Calendar for multiple event dates

    Hello,I am trying to add a Master Calendar to my model, and the challenge is that there are many different 'event' dates that occur in my data set.&nb... Show More

    Hello,

    I am trying to add a Master Calendar to my model, and the challenge is that there are many different 'event' dates that occur in my data set.  We have Referral, Start-of-Care, Non-Admission, Visit, EpisodeStart, EpisodeEnd, Budget dates, etc.  The main fact tables are the Episode and Visit tables.  The model is working okay, but I want to optimize and have the ability to filter on a master time dimension.  In the current state, the connections are creating 3 synthetic tables.

    I am looking for some suggestions on the overall structure.  Most everything is driven off of the StartOfCare date, but I also want to report Referrals and NonAdmissions on the same timeline.  I am posting in the Healthcare Group, as I'm sure you all have encountered some of the same issues.

    Any thoughts are most appreciated

    Model wo Master Calendar 9-2018.JPG

    Show Less
Group details
Qlik Healthcare User Group
Qlik Healthcare User Group
776 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
jaw Employee
Dalton_Ruer Employee
Members (776)