Using two select statement in the data laod

[#1]

I am trying to query same database but different tables using SQL language with two SELECT statement from the data load editor  but it keeps giving me error. But my query separately when tested on my SQL developer??  Does qlik sense not allow using more than one Table.

[avinashelite]

Try this

SQL SELECT *

FROM ARADMIN."VOC_FEEDBACK_V2_VIEW"

WHERE CREATE_DATE > 18000 AND YEAR > 2016 

    AND CATEGORY in(

'ARCHIVE QUICK CHECK',

'CLINICAL DATA VISIBILITY TOOL',

'CLIN PHARM MODELING SIMULATION ANALYSIS WORKFLOW',

'CPMS AW',

'DATASET MANAGER',

'EDX - ELECTRONIC DOC EXCHANGE',

'ENAVIGATOR',

'GSP - GSK STUDY PORTAL',

'HARP',

'HARP SUITE',

'HIF - HEALTHCARE INFO FACTORY',

'HEALTHCARE INFO FACTORY VISUALISATION',

'INET CATALIST',

'INSIGHT (STUDY MANAGER)',

'PREDICTIVE MODELLING',

'PREDICTIVE MODELLING ENVIRONMENT (PME)',

'RBM - RISK BASED MONITORING',

'SITE OPTIMIZER',

'SPECTRE',

'STUDY ALLOCATION AND RESOURCING SYSTEM (STARS)',

'STUDY OPTIMIZER',

'SUPPLIER CONTRACTS',

'TSCG - TIBCO SPOTFIRE CLINICAL GRAPHICS',

'TRANSFER OF OBLIGATIONS')

    AND RA in ('RD-IT-SUPPORT-SATYAM',

                                      'IT-RDIT-SUPPORT',

                                      'RD-IT-SUPPORT-WIPRO',

                                      'List of RAs');

SQL SELECT TICKET_ID_

      ,concat('https://vocfeedback.gsk.com/IM_view/ticketInfo.asp?ticket_id=',TICKET_ID_) as Ticket_Link

      ,SUB_CODE

      ,OPENING_TYPE

      ,OPENING_CATEGORY

      ,OPENING_SUB_CODE

      ,PRIORITY AS Priority_Number

FROM INCIDENT_MANAGEMENT

where to_date(ARADMIN.get_rem_date(CREATE_TIME), 'Month DD, YYYY HH:MI:SSAM') > to_date('01/01/2016', 'MM/DD/YYYY')

  and to_date(ARADMIN.get_rem_date(CREATE_TIME), 'Month DD, YYYY HH:MI:SSAM') < to_date('01/01/2018', 'MM/DD/YYYY')

  AND (ASSIGNED_TO_GROUP_ = 'RD-IT-SUPPORT-SATYAM' OR ASSIGNED_TO_GROUP_ = 'IT-RDIT-SUPPORT' OR ASSIGNED_TO_GROUP_ = 'RD-IT-SUPPORT-WIPRO')

  AND CATEGORY in(

'ARCHIVE QUICK CHECK',

'CLINICAL DATA VISIBILITY TOOL',

'CLIN PHARM MODELING SIMULATION ANALYSIS WORKFLOW',

'CPMS AW',

'DATASET MANAGER',

'EDX - ELECTRONIC DOC EXCHANGE',

'ENAVIGATOR',

'GSP - GSK STUDY PORTAL',

'HARP',

'HARP SUITE',

'HIF - HEALTHCARE INFO FACTORY',

'HEALTHCARE INFO FACTORY VISUALISATION',

'INET CATALIST',

'INSIGHT (STUDY MANAGER)',

'PREDICTIVE MODELLING',

'PREDICTIVE MODELLING ENVIRONMENT (PME)',

'RBM - RISK BASED MONITORING',

'SITE OPTIMIZER',

'SPECTRE',

'STUDY ALLOCATION AND RESOURCING SYSTEM (STARS)',

'STUDY OPTIMIZER',

'SUPPLIER CONTRACTS',

'TSCG - TIBCO SPOTFIRE CLINICAL GRAPHICS',

'TRANSFER OF OBLIGATIONS')

;

[#3]

Hi Sacchin,

   It's still not working, showing the error below:

"

Started loading data

Connecting to Remedy

Data has not been loaded. Please correct the error and try loading again."

and I started my statement like the below:

LIB CONNECT TO 'Remedy';

SQL

Select *
  FROM ARADMIN."VOC_FEEDBACK_V2_VIEW"
  WHERE CREATE_DATE > 18000 AND YEAR > 2016  ..............

[#4]

Hi Avinash,

    Unfortunately still not working.

"

The following error occurred:

Connector reply error: ***

The error occurred here:

?

Data has not been loaded. Please correct the error and try loading again."

[#5]

HI Rahul,

   Please look at my replies to other comments, I have answered your question. Thanks

[avinashelite]

share the app ...

[#7]

Can I share with just the Qlik sense Desktop?? cant find a share button??

[#8]

Hi Avinash,

  As Requested, I have shared. Thanks for your attention.

[avinashelite]

Oh !! sorry man I don't have Qliksense installed

[#10]

I have shared it already Avinash, look at my replies. I googled it.

[#11]

I have shared the App.