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