Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
PFA.
I am trying to implement direct discovery in my app it is not working.Can u plz suggest on this.
Thanks
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";
Measure are invisible when ever i m trying to reload
measure
"AR_OpenAmount",
"AR_OpenAmount_USD"
on dashboard
Would you share data in excel. Will try from my end
PFA.
Test data in excel.
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";
Can u plz share ur qvw file
Hope helps
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
Thanks Paridhi.
My Qlik version is 32 bit and system is 64 bit so that issue persist.
Thanks