Direct discovery not working

[deepakqlikview_123]

Hi All,

PFA.

I am trying to implement direct discovery in my app it is not working.Can u plz suggest on this.

Thanks

[Anil_Babu_Samineni]

Remove comma from measure end. try this?

DIRECT QUERY

dimension

"AR_AAI",

    "AR_AAIDesc",

    "AR_CO",

    "AR_ComCode",

    "AR_Curr",

    "AR_CurrentPeriod",

    "AR_CurrentYear",

    "AR_DATE",

    "AR_Month",

    "AR_Obj",

     "AR_PBU",

    "AR_PBUHQ",

    "AR_Sub",

    "AR_Year",

        "Get_Date",

    "HIER_ID"

   measure

    "AR_OpenAmount",

    "AR_OpenAmount_USD"

FROM dbo."AR_CustomerLedger";

[deepakqlikview_123]

Measure are invisible when ever i m trying to reload

measure

    "AR_OpenAmount",

    "AR_OpenAmount_USD"

on dashboard

[Anil_Babu_Samineni]

Would you share data in excel. Will try from my end

[deepakqlikview_123]

PFA.

Test data in excel.

[Anil_Babu_Samineni]

By using PostgreSQL DB. I am getting in it.

Connection here

[testdata1]:

DIRECT QUERY

dimension

  "ar_aai",

  "ar_aaidesc",

  "ar_co",

  "ar_comcode",

  "ar_curr",

  "ar_currentperiod",

  "ar_currentyear",

  "ar_date",

  "ar_month",

  "ar_obj",

  "ar_pbu",

  "ar_pbuhq",

  "ar_sub",

  "ar_year",

  "companyid",

  "fiscalmonth",

  "fiscalyear",

  "get_date",

  "hier_id"

measure

  "ar_openamount",

  "ar_openamount_usd"

FROM "public"."testdata1";

[deepakqlikview_123]

Can u plz share ur qvw file

[Anil_Babu_Samineni]

Hope helps

[Anonymous]

Hi Deepak,

Maybe this will help you!!

ODBC CONNECT32 TO [Excel;DBQ=C:\Users\mantri_p\Desktop\New folder\testdata.xls];

DIRECT QUERY

dimension

AR_AAI,

     AR_AAIDesc,

     AR_CO,

     AR_ComCode,

     AR_Curr,

     AR_CurrentPeriod,

     AR_CurrentYear,

     AR_DATE,

     AR_Month,

     AR_Obj,

     AR_PBU,

     AR_PBUHQ,

     AR_Sub,

     AR_Year,

     COMPANYID,

     FiscalMonth,

     FiscalYear,

     Get_Date,

     HIER_ID

  measure

    AR_OpenAmount,

     AR_OpenAmount_USD 

FROM

Sheet1$;

Thanks

Paridhi Sodani

[deepakqlikview_123]

Thanks Paridhi.

My Qlik version is 32 bit and system is 64 bit so that issue persist.

Thanks