Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
avelasquezross
New Contributor

do not load data

Hello Good morning, I'm new to Qlik Sense, I'm making an app that connects to my Oracle database, and I'm doing a join in the select, but the data doesn't load me.

Set dataManagerTables = '','BI_OPORTUNIDAD_PIPE_drive','TAL_HITO';

//This block renames script tables from non generated section which conflict with the names of managed tables

For each name in $(dataManagerTables)

    Let index = 0;

    Let currentName = name;

    Let tableNumber = TableNumber(name);

    Let matches = 0;

    Do while not IsNull(tableNumber) or (index > 0 and matches > 0)

        index = index + 1;

        currentName = name & '-' & index;

        tableNumber = TableNumber(currentName)

        matches = Match('$(currentName)', $(dataManagerTables));

    Loop

    If index > 0 then

            Rename Table '$(name)' to '$(currentName)';

    EndIf;

Next;

Set dataManagerTables = ;

Unqualify *;

LIB CONNECT TO 'Oracle.us-west-2.compute.amazonaws.com'; // This connection is fine but for the sake of the information you don't write everything-

   [REPORTES]:

Load

              [COD_PROYECTO] AS [TAL_HITO.COD_PROYECTO],

              [SERIAL_HITO] AS [TAL_HITO.SERIAL_HITO],

              [COD_CONTRATO],

    [ID_OPOPD],

    [COD_PROYECTO],

    [DES_HITO],

              [FECHA_VENC],

              [PRJ_DELTOTAL],

              [MTOUF_HITO],

              [COD_APROB_CLTE],

              Date(Date#([FECHA_REALHITO], 'DD/MM/YY') ) AS [FECHA_REALHITO],

              [COD_TIPOHITO],

              [FECHA_FORMALIZA],

              [FECHA_PAGOREAL],

              [FECHA_GAF],

              [ID_OPORTUNIDAD], 

              [DESCRIPCION],

    [STATUS],

              [OWNER_NAME],

              [COD_ESTADO],

              [FORMATTED_WEIGHTED_VALUE],

              [FECHA_REGISTRO],

              [WON_TIME],

              [CLOSE_TIME],

              [SERIAL_HITO];

 

SELECT NVL(h."COD_PROYECTO", p."OWNER_NAME") COD_PROYECTO,

NVL(TO_CHAR(h."SERIAL_HITO"), p."OWNER_NAME") SERIAL_HITO,

NVL(h."COD_CONTRATO", p."OWNER_NAME") COD_CONTRATO,

NVL(p."ID_OPOPD", p."OWNER_NAME") ID_OPOPD,

NVL(p."COD_PROYECTO", p."OWNER_NAME") COD_PROYECTO,

h."DES_HITO",

h."FECHA_VENC",

h."PRJ_DELTOTAL",

h."MTOUF_HITO",

h."COD_APROB_CLTE",

h."FECHA_REALHITO",

h."COD_TIPOHITO",

h."FECHA_FORMALIZA",

h."FECHA_PAGOREAL",

h."FECHA_GAF",

h."ID_OPORTUNIDAD",

p."DESCRIPCION",

p."STATUS",

p."OWNER_NAME",

p."COD_ESTADO",

p."FORMATTED_WEIGHTED_VALUE",

p."FECHA_REGISTRO",

p."WON_TIME",

p."CLOSE_TIME",

p."SERIAL_HITO"

from "ALIGARE_USER"."TAL_HITO" h , "ALIGARE_USER"."BI_OPORTUNIDAD_PIPE_drive" p

where

RTRIM(h.COD_PROYECTO) = p."COD_PROYECTO" (+);

 
Could you please help me, I am doing my engineering practice and, the company wants to know if they follow or not Qlik Sense.

regards

ANGE

 

 

 

 

1 Reply
Highlighted
Partner
Partner

Re: do not load data

Are you sure the SQL query returns results? This would be the first thing I would test, preferably in your database tool ,not Qlik.

It may not make a difference but I would change "SELECT" to be "SQL SELECT".

One error I see is that you have two columns aliased to "COD_PROYECTO".  You need to make the names unique within a table. Qlik will load the query output by column's name, not order. So at the moment I don't see how Qlik would know which column to use.

Blog: WhereClause   Twitter: @treysmithdev