topic Re: Direct discovery not working in QlikView

Direct discovery not working

deepakqlikview_123 — Thu, 30 Mar 2017 12:57:03 GMT

Hi All,

PFA.

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

Thanks

Re: Direct discovery not working

Anil_Babu_Samineni — Thu, 30 Mar 2017 13:41:10 GMT

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";

Re: Direct discovery not working

deepakqlikview_123 — Fri, 31 Mar 2017 06:08:42 GMT

Measure are invisible when ever i m trying to reload

measure

"AR_OpenAmount",

"AR_OpenAmount_USD"

on dashboard

Re: Direct discovery not working

Anil_Babu_Samineni — Fri, 31 Mar 2017 06:14:00 GMT

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

Re: Direct discovery not working

deepakqlikview_123 — Fri, 31 Mar 2017 08:26:52 GMT

PFA.

Test data in excel.

Re: Direct discovery not working

Anil_Babu_Samineni — Fri, 31 Mar 2017 10:31:57 GMT

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";

Re: Direct discovery not working

deepakqlikview_123 — Fri, 31 Mar 2017 11:15:03 GMT

Can u plz share ur qvw file

Re: Direct discovery not working

Anil_Babu_Samineni — Fri, 31 Mar 2017 11:48:58 GMT

Hope helps

Re: Direct discovery not working

Anonymous — Fri, 31 Mar 2017 12:34:43 GMT

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

Re: Direct discovery not working

deepakqlikview_123 — Fri, 31 Mar 2017 14:12:20 GMT

Thanks Paridhi.

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

Thanks