Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
deepaktibhe
Valued Contributor

Direct discovery not working

Hi All,

PFA.

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

Thanks

9 Replies
Highlighted

Re: Direct discovery not working

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
deepaktibhe
Valued Contributor

Re: Direct discovery not working

Measure are invisible when ever i m trying to reload

measure

    "AR_OpenAmount",

    "AR_OpenAmount_USD"


on dashboard

Highlighted

Re: Direct discovery not working

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
deepaktibhe
Valued Contributor

Re: Direct discovery not working

PFA.

Test data in excel.

Highlighted

Re: Direct discovery not working

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

Capture.PNG

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
deepaktibhe
Valued Contributor

Re: Direct discovery not working

Can u plz share ur qvw file

Highlighted

Re: Direct discovery not working

Hope helps

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
paridhimantri
Contributor

Re: Direct discovery not working

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

Highlighted
deepaktibhe
Valued Contributor

Re: Direct discovery not working

Thanks Paridhi.

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

Thanks